import question

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

This is a continue from a previous question: I have an
employee table on sequel that is done in Access
2003 and want to link to an excel spreadsheet, so that
when the user looks at the records in excel they
cannot delete from the sequel table?
I was told to Import External Data in Excel. I did this
and the only problem: is that you can make changes to
this database. Is 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?
 
Hi
if you want to prevent changes you have to protect the worksheet.
Automatically updating is possible after reopenening the file or
setting the refresh option accordingly
 
Thanks,
-----Original Message-----
Hi
if you want to prevent changes you have to protect the worksheet.
Automatically updating is possible after reopenening the file or
setting the refresh option accordingly

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
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 access to excel 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Excel Import External Data by Date Automatically 0
Easy Steps to Import PST Files to Office 365 0
Microsoft Works to Microsoft Office 6
Import External Data by Date 2
Import Access Table into Excel 3

Back
Top