Primary Key with Imported Text

[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

 

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

 

[SITCFanTN]

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