Choosing where the imported fields go in existing tbl

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

Jeff Boyce

What do you mean by "a template table"?

It would be quite unusual to require chosing a "destination field for each
field in the ... imported" text file ... if your Access tables were
well-normalized.

It all starts with the data. Please describe the data you are importing,
and the structure into which you are trying to move it.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing a text file - choosing where the fields end up 1
Import fields from .csv with variable column structure 4
How to show imported field as date format DD-MMM-YY 2
Error importing to Access - file was not imported 1
non-imported fields with errors 3
Problems Importing Excel Files to an Existing Table 1
Adding a reference field to imported spreadsheet table 3
Text to date conversion 5

Top