By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,572 Members | 963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,572 IT Pros & Developers. It's quick & easy.

trouble importing comma delimited files

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.com> wrote in message
news:d5**********@reader1.panix.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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.