Error writing to Linked Excel Table

[Joe]

I have an Excel table linked in an Access 2000 Database.
If I use a form to write to the excel table, the form
accepts the data and closes without errors. However, if I
then try to open the linked table, I receive the "External
table is not in the expected format." error. If I try to
open the Excel workbook, it starts to open, and then I get
the "Microsoft Excel for Windows has encountered a problem
and needs to close. We are sorry for the inconvenience."
error message and Excel closes.

Before attempting to write to one of the fields, I had no
problem opening the linked table and the Excel workbook
directly.

Any idea what may be causing this problem?

Thanks,
Joe

 

[LPooler]

I have tried to figure this out several times but believe there is a
problem between Access and Excel. See the attached posting.

http://groups.google.com/groups?hl=...10300157.46ba78ff%40posting.google.com&rnum=1