Load Excel into Access Database - Connectivity Problem.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

luis.a.roman@gmail.com - 01 Jul 2007 01:15 GMT

How can I set up connectivity from an Excel Worksheet to an access
database? Would like to load a worksheet into an access database using
the Docmd.TransferSpreadsheet. However, I'm getting that I don't have
the database open.

Suggestion will be greatly appreciated.

Luis

Reply to this Message

FSt1 - 01 Jul 2007 03:18 GMT

hi,
why emport it. why store the same data in two different places.
Link to it.
Declare the data in your excel sheet as a named range. access will view this
named range as a table and you can link to it from access and use it as any
other access table.

regards
FSt1

> How can I set up connectivity from an Excel Worksheet to an access
> database? Would like to load a worksheet into an access database using
[quoted text clipped - 4 lines]
>
> Luis

Reply to this Message

Rate this thread: