trouble importing comma delimited files

[don]

I'm trying to import a comma delimited text file into MS Access 2002
version - the first column is set for an auto increment primary key and
everything works right the first time I import a text file, however when I
try to append to this new database table Access always messes up the
import - as long as I ieave the auto increment column out it has no trouble
appending to the database , and then I have to add the auto increment column
afterwards? What am I doing wrong or is this a bug in the software?

[David Lloyd]

Don:

My understanding is that you can not reference in an autoincrement field
when appending to a table, whether you are using an INSERT SQL query, or the
importing text data.

One possible solution, is to remove the autoincrement field from the import
specification for appending operations. A second alternative, if you are
sure the autoincrement field you are importing is unique and you want to use
it as your primary key, is to not make the table column an autoincrement
column.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"don" <do*@panix.co m> wrote in message
news:d5******** **@reader1.pani x.com...
I'm trying to import a comma delimited text file into MS Access 2002
version - the first column is set for an auto increment primary key and
everything works right the first time I import a text file, however when I
try to append to this new database table Access always messes up the
import - as long as I ieave the auto increment column out it has no trouble
appending to the database , and then I have to add the auto increment column
afterwards? What am I doing wrong or is this a bug in the software?