I import data. I want my data comes with row number 1,2,3,.......................................I have used auto number in table but when I append something it mess up all numbers. Your help appreciated. thx.
Competent Performer
Windows XP 
Access 2007
I import data. I want my data comes with row number 1,2,3,.......................................I have used auto number in table but when I append something it mess up all numbers. Your help appreciated. thx.
VIP
Windows 7 64bit Access 2007
If you are wanting a unique number, an ID field with autonumber datatype should work. As you append records it will generate unique numbers. Now it may skip numbers if you delete some records, etc. but should always be a unique number.
VIP
Windows 7 64bit Access 2010 32bit
Why would appending data mess up all numbers? Exactly how are you appending?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Totals Query: Min And Max of Last 6 Digits of 10-digit Serial Number
Processor Serial Number
Posting Permissions
Reply With Quote