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.
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.
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.
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.