How to import and map data fields

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