Load Excel into Access Database - Connectivity Problem.

  • Thread starter Thread starter luis.a.roman
  • Start date Start date
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
 
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
 
Back
Top