Excel File Corruption when Linking to Access Database

V

Van T. Dinh

Sorry, not a direct answer.

I have had similar experiences with Access2K using Excel2K
spreadsheets as linked Tables. Since then I avoid using
Excel spreadsheets as linked Tables at all costs.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Is there a fix for this problem?

When I Link an Excel file to an Access database (Office
Click to expand...
2003), the file will usually get corrupted if I try to run
any queries on it. The only way I have been able get
around this is to first save the Excel file as an Excel
5.0/95 file type, which limits the features. Is there any
way to fix this so I can use current versions of Excel?
 

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
Merging from an Excel file with graphics 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Adding data to MS Access from csv file 0
Active Content in this file is blocked issue 1
Autonumber field in Excel that behaves the same as Access 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Linked Excel File won't update 1

Top