Prev: TESTE
Next: Access crash
From: Tom Benson on 26 Jan 2010 13:26
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?
From: Douglas J. Steele on 26 Jan 2010 13:31
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.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Tom Benson" <tombensonldi(a)gmail.com> wrote in message
news:b30e8329-8f86-436f-83d5-7dca021d8e52(a)a12g2000yqj.googlegroups.com...
> 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?


From: Tom Benson on 26 Jan 2010 13:56
True. Good enough! Thanks.
 | 
Pages: 1
Prev: TESTE
Next: Access crash