How to import and map data fields

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

 

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