Import Excel data - need to map columns.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

diode - 13 Jan 2008 23:31 GMT

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.

Signature

Thank you for your help.

Reply to this Message

Arvin Meyer [MVP] - 14 Jan 2008 00:27 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>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
[quoted text clipped - 10 lines]
> be
> appreciated.

Reply to this Message

Peter Hibbs - 14 Jan 2008 15:53 GMT

Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Excel%20to%20Ac
cess%20Converter%20Utility%20program'
which may be able to do it for you automatically.

HTH

Peter Hibbs.

>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
[quoted text clipped - 6 lines]
>Is there a WSIWYG wizard method, or do I have to use VBA? Any help would be
>appreciated.

Reply to this Message