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

Jim/Chris

Use the File/Get External Data/Link. The linked Excel file
name will be the sheet name

Jim
 

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

Visio to Excel 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Embed the same Excel multiple times 0
Merging from an Excel file with graphics 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Update several ppt documents from a single excel file 0
Page numbering with Merged Document and IF statements 1
Autonumber field in Excel that behaves the same as Access 0

Top