Export to Exel using Access 2000 and 2007

S

Samantha

Most of us are using MsAccess 2000 and some are starting to migrate to 2007
because of their system has been upgraded to MsOffice 2007.
My problem is that I have created MsAccess reports using 2000 and it exports
find with the following script, but does not work in MsAccess 2007.
Can anyone help me with this?

This is what I'm using to export a report to Excel (which works fine in
MsAccess 2000):
DoCmd.OutputTo acOutputReport, strName, acFormatXLS

Thanks in advance.
 
R

RitchieJHicks

As I understand it, the format in Office 2007 hae changed and an XLS file is
now an XLSX file. Could this be the cause of the problem?
 

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

Slow MDE Performance with MSAccess 2007 1
Export to spreadsheet error, help please 2
Export Access Table and format it in Excel 2
Export to Excel Problems 2
Export report 4
Export from 2007 using Export Specification. 2
Choosing Excel version 2
Export Subform Filter to Excel 5

Top