TransferSpreadsheet Excel 2007 into Access 2003

T

Tom Benson

How can I TransferSpreadsheet Excel 2007 into Access 2003?

This does not work:

DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblSomeData", "C:
\DataFolder\SomeData.xlsx", True, "Sheet1$"

If I save as an xls it will work:

DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblSomeData", "C:
\DataFolder\SomeData.xls", True, "Sheet1$"

Do I need to do that? Is there another way?
 
D

Douglas J. Steele

Since Access 2003 came out long before Excel 2007 was designed, it seems
logical that it doesn't know anything about the Excel 2007 file format. The
Access developer team is good, but it would have required a lot of
prescience to be able to predict future file formats!

Saving in a legacy file format makes sense.
 

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

Export spreadsheet method in 2007 Access 6
Transferspreadsheet - insert rows with no header 1
Transferspreadsheet to import excel file with different column 5
MSysObjects permissions 2
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
Export Access pivot table to Excel - VBA solution 0
Export Report with Graph to Excel error 2495 1
TransferSpreadsheet to Excel limit 5

Top