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

Importing a text file into a table

P: 84
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?
Sep 4 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,383
Import into a different table and then append it to the original table.
Sep 4 '07 #2

P: 84
Import into a different table and then append it to the original table.
That worked. Thx for all your help
Sep 4 '07 #3

Rabbit
Expert Mod 10K+
P: 12,383
Not a problem, good luck.
Sep 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.