Importing a text file - choosing where the fields end up

  • Thread starter Thread starter jamesB
  • Start date Start date
J

jamesB

Importing a text file into Access

I would like to set up a process whereby i can choose where each field of
the imported text file goes in a template table.

i.e. i would like a prompt in the import process requesting me to enter the
destination field for each field in the text file to be imported?
 
The only way that I was ever able to solve mapping imported fields is to use
a linked table,instead of an imported one, then use a query to append the
records to an internal table. By doing that, one can change field names and
massage data to fit the way it's needed.
 
Back
Top