Primary Key with Imported Text

S

SITCFanTN

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.
 
S

SITCFanTN

I've never done that before, can you give me some advice on how to do it
please.
 
Top