Access & Excel

[JoeM]

How can I set up an access database to pull in an excel document?
Example: I need the access document to always reopen or look into the excel
document everytime to access document is opened.

Thanks

 

[Guest]

Try File | Get External Data | Link Tables | Files of type *.xls

 

[JoeM]

Thank you, your suggstion seems to be working. Thankyou