How to import and map data fields

T

Travis

Im trying to import data from several sources and teh
fields are in different orders. How can I map the dat
from each file to import correctly into its corresponding
fields in my table?
 
J

John Nurick

Hi Travis,

Import or link the data source to a new, temporary, table. Then use an
append query to move the data to the "permanent" table, sorting out the
field names making any other adjustments you need. Finally delete the
temporary table.
 
Top