471,355 Members | 1,621 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

Import Excel Worksheet to BackEnd Access Database



I would like to import an Excel Worksheet as a new table in the backend
of an Access database.

Looked at using docmd.TransferSpreadsheet without success. Also looked
at creating a table using the tabledef method but am stuck on the
importing of the Excel Worksheet.

Any assistance would be GREATLY appreciated as I have been working on
this way too long now.

THANKS!

FireGeek

*** Sent via Developersdex http://www.developersdex.com ***
Jan 30 '07 #1
1 2314
Tammy Viola wrote:
>
I would like to import an Excel Worksheet as a new table in the backend
of an Access database.

Looked at using docmd.TransferSpreadsheet without success. Also looked
at creating a table using the tabledef method but am stuck on the
importing of the Excel Worksheet.

Any assistance would be GREATLY appreciated as I have been working on
this way too long now.

THANKS!

FireGeek

*** Sent via Developersdex http://www.developersdex.com ***
In the backend create a link to the excel document. Now you can treat it
like a local table (even though it's not).

If you want to go one step further you could execute a query like

SELECT * INTO [NEWTABLE]
FROM [LINKED_EXCEL]

This will duplicate the excel table data in a bona fide Access table. If
you do this you will probably want to examine the new table's properties
and set up a primary key and any other required indexes [doesn't anyone
say "indices"?].

--
Smartin
Jan 30 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.