Export to Exel using Access 2000 and 2007

  • Thread starter Thread starter Samantha
  • Start date Start date
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.
 
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?
 
Back
Top