Primary Key with Imported Text

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top