Link individual Excel files to one Access database

  • Thread starter Thread starter jrh
  • Start date Start date
J

jrh

Is there any way, without programming codes, to link
individual Excel 2003 wookbooks to one common Access 2003
database? Thanks for your input.
 
Hi

Define all tables in workbooks as named ranges.
Link tables to Accsess database (Files.GetExternalData.LinkTables - set file
type to *.xls and select workbook, select 'Show named ranges' and then table
you want to link.
 
Back
Top