Importing a text file - choosing where the fields end up

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

 

[Arvin Meyer [MVP]]

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.