Primary Key with Imported Text

G

Guest

I'm importing data into a table from a TXT file. Everything works great as
long as my table field names exactly match my TXT file. Once I add a Field
Name for Auto Assign the Primary Key number (which is just a count of 1, 2,
3... this data is not part of the TXT file), the TXT file won't import. Any
idea what I'm doing wrong? thank you
 
P

Pat Hartman \(MVP\)

When your source and target tables have different column names or different
sets of columns or different order to the columns, you need to specifically
map the source/target pairs in your append query.
 

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

create primary key from filename of .txt file 7
Primary Key Help 3
Import date field problem. 1
File Location Prompt 3
Adding auto-numbered Primary Key to imported tables. 5
Update primary Key. 1
System Resource Exceeded 5
Primary Keys in imported data 3

Top