How to add ID field automatically

G

Guest

I am trying to import 3 text comma delimited files but after the data is
imported I don't find a field ID which MS Access usually asks in the manual
process to add if it doesn;t find primary key in your table. I need to know
how shall I make this work in an automated process
 
J

Jeff Boyce

One approach would be to append the new data to a table that already has
such a field defined, rather than importing into a new table.

Regards

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Text Files Into Access 1
Using a macro to change Field Properties 5
Automate the Uncheck 1
saving on screen data to comma delimetted text file 0
Change Data Type in a Field Common to 200 Tables 3
Concatenate Date and Number field for Append Query 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Append Query to add unrelated info from one table to another ... 3

Top