Export to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete S - 05 Aug 2004 15:47 GMT

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?

Reply to this Message

John Nurick - 06 Aug 2004 07:07 GMT

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?

>We have a database that has been converted to 2000 from
>97. The database outputs queries and tables to Excel.
[quoted text clipped - 11 lines]
>
>Any suggestions?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

pats - 30 Sep 2004 11:02 GMT

Hi,

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

> We have a database that has been converted to 2000 from
> 97. The database outputs queries and tables to Excel.
[quoted text clipped - 11 lines]
>
> Any suggestions?

Reply to this Message