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.
..
 
Use the File/Get External Data/Link. The linked Excel file
name will be the sheet name

Jim
 
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
Changing Links to access databases 1
Advantages and disadvantages of individual file based compression and inter-file compression 1
Record-Locking remains open after closing 0
how do i merge one access database to another access data base 4
Linked Excel File won't update 1
Share Access database between Access 2007 & 2003 1
Linking Multiple Excel Files to One Access Database 3

Back
Top