TransferSpreadsheet Access 2003 to Excel 2007 Error

B

BJ

I've had Excel 2007 installed and still run Access 2003 on my PC. The
following code ran fine when Excel 2003 was on my PC, but since using
2007 it generates an error.

'Transfer the recordset data to the workbook.
DoCmd.TransferSpreadsheet acExport, , QueryName, strNewWorkbookPath
_
, , NamedFormula

The error details are:
err.Number
3274

err.Description
External table is not in the expected format.

Any ideas as to possible fixes for this 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

TransferSpreadsheet Error, Access 2003 to Excel 2007. 3
TransferSpreadsheet Excel 2007 into Access 2003 2
Export Report with Graph to Excel error 2495 1
Export spreadsheet method in 2007 Access 6
personal excel macro causing access not to open excel file 0
Access 2003 and excel 0
Problem with TransferSpreadsheet - memo fiedl gets truncated 1
Saving Excel from Access 1

Top