Import Excel data - need to map columns.

D

diode

I am tryimg to import a simple, small Excel worksheet into a newly created
Access table. The table has the columns for the existing data, plus
additional columns I need.
When I try to do this it seems Access is trying to map the Excel columns in
order of the Access columns (my guess) as it complains about the transfer and
all records end up in a error table. I tried the CSV route with the
'advanced' button but that only allowed me to skip columns, not map specific
columns between the two data tables.
Is there a WSIWYG wizard method, or do I have to use VBA? Any help would be
appreciated.
 
A

Arvin Meyer [MVP]

No wizard, but if I understand what you want correctly, you can either Link
or Import the Excel data first, then run an update or append query to move
the data to the final destination. You can do that manually, or create a VBA
routine to do it.
 
Top