Export to Excel

[Pete S]

We have a database that has been converted to 2000 from
97. The database outputs queries and tables to Excel.
This has worked correctly in the 97 version. In 2000 we
get a cannot update; database or object is read only.

Works also if you perform the export manually.

Have tried different excel versions.

Code:
DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel7, "qrySAL2_4", outdir
& "BillErrors" & seldate & ".xls"

Any suggestions?

 

[John Nurick]

Hi Pete,

Is this the problem described at http://support.microsoft.com/?id=250459
?

When you say "works also if you perform the export manually", do you
mean that the export succeeds, or that you also get the error?

 

[Guest]

Hi,

Have you found a solution to this problem? I am also having this problem now.