Importing a text file into a table

[sesling]

I am having trouble importing a text file into my access db. My data is in a comma delimited file. I created a table with an autonumber column. When I import the text file it puts the first column of data from the text file in the autonumber field. Is there a way to import data into a table that has an autonumber column?

[Rabbit]

Import into a different table and then append it to the original table.

[sesling]

Import into a different table and then append it to the original table.

That worked. Thx for all your help

[Rabbit]

Not a problem, good luck.