By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,569 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,569 IT Pros & Developers. It's quick & easy.

Import Excel Worksheet to BackEnd Access Database

P: n/a


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
Share this Question
Share on Google+
1 Reply


P: n/a
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.