Importing a text file

[matthewschmitt]

I am trying to import a delimited text file into a table, but I can't get the table to give me an autonumber primary key....i keep getting an import error when I have a record_id field in the table. Any suggestions?

 

[Norie]

Are you trying to import into an existing table with an autonumber field?

 

[matthewschmitt]

Yes

 

[Norie]

Are you trying to place values from the text file into the autonumber field?

If you are then you will get an error.

 

[matthewschmitt]

how do I import it so it doesnt try to populate the autonumber field?

 

[Norie]

How are you doing the import?

Are you using the Import wizard? If you are you can choose not to import the offending field.