link access to excel

P

Pam

I have an employee table on sequel that is done in Access
2003 and want to link to an excel spreadsheet for a user
that is familiar with excel over access. Is there an easy
way to link this and keep the excel records updated so
that when the user looks at the records in excel they
cannot delete from the sequel table?
 
P

Pam

I have tried the Import External Data in Excel. The only
problem I don't understand is that you can make changes to
this database. If there any way to import this to excel
and not allow for changes but allow the user to filter out
information? Also will my excel spreadsheet update
automatically when the access db is updated?
 

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

Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5
Merging from an Excel file with graphics 1
Autonumber field in Excel that behaves the same as Access 0
Integrating information from Word to Excel (not mail merge) 1
import question 2
Excel - Wich Function should I use? 1
Adding data to MS Access from csv file 0

Top