Exporting query to Excel.

[mbowler9]

I have a database that until recently would export 50 reports with the DoCmd.Transferspreadsheet command. Well, I had computer problems that required me to reintall Access and now when I do this I get an error 3027 "Database or object is locked or read only". I tried to export the query with "Save As", but when I get to the part where I select "Excel 97" from the drop-down, it isn't there.

Any suggestions?

Thanks

 

[JR2913]

Have you checked to see that a reference exists to the Microsoft Excel Object Library thorugh Tools - References in VBA?

John R

 

[RJFost]

Also, check that the "Advanced Wizards" were included in the installation list for Access.

 

[mbowler9]

The reference to Excel 10.0 is present.

When I installed Access I selected "Install All". Is there a way to specifically check if "Advanced Wizards" is installed?

Thanks

 

[JR2913]

It looks as though this might be an ODBC error - try

http://support.microsoft.com/default.aspx?scid=kb;en-us;209943&Product=acc2000

which looks at a resolution to the particular error message you are getting.

Regards

John R