Hi,
I import data from a text file into an existing table. The text file has no column headings, so I delete all records from my existing table and populate it with data from the text file each tim. I need the ID autonumber field. However, the ID autonumber field numbers gets very big with each table erase and new import. Is there any way to reset this ID Autonumber field?
The field seems to rember the count from the last table before the delte. It will not even remove the ID field and resetinstaet it with ethe same name or different name. Please help. You may email me directly as well at cchetty@austin.rr.com and post the solution (if you have one) in this thread.
Thanks!
Chris.