Import into Table error

[Guest]

I converted a access 97 database into 2000 format. I am trying to import a
text file where the first column is an auto number. When i attempt this i
receive and error of not all data imported successfully. When i viewed the
table i noticed that my "auto number" was actually being populated by the
first column from my text file which i was importing. Please help.... S. Sant

 

[John Nurick]

One common way round this (and most other problems with numbers, names
and types of fields) is to link or import the text file to a temporary
table and then use an append query to move the data into your "main"
table.

In this instance, if you omit the autonumber field from the append query
it will generate its own values for the imported records.