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