Link individual Excel files to one Access database

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.
 
A

Arvi Laanemets

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.
 
Top