Load Excel into Access Database - Connectivity Problem.

L

luis.a.roman

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
 
F

FSt1

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
 
Top