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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link individual Excel files to one Access database 1
Export Excel data to Access 6
Changing Database links? 3
Linking issues 3
Advantages and disadvantages of individual file based compression and inter-file compression 1
Checking/amending the external source link to an Access table 1
Can I view multiple tabbed worksheet in the same workbook in Excel 1
Alphabetizing mulitiple worksheets in Excel 2003? 2

Back
Top