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?
|
|
0
|
|
|
|
Reply
|
 Tom
|
1/26/2010 6:26:15 PM |
|
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@gmail.com> wrote in message
news:b30e8329-8f86-436f-83d5-7dca021d8e52@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?
|
|
|
-1
|
|
|
|
Reply
|
Douglas
|
1/26/2010 6:31:19 PM
|
|
True. Good enough! Thanks.
|
|
|
0
|
|
|
|
Reply
|
Tom
|
1/26/2010 6:56:20 PM
|
|
|
2 Replies
787 Views
(page loaded in 0.8 seconds)
Similiar Articles: TransferSpreadsheet Excel 2007 into Access 2003 - microsoft.public ...How can I TransferSpreadsheet Excel 2007 into Access 2003? This does not work: DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblSomeData... TransferSpreadsheet Access 2003 to Excel 2007 Error - microsoft ...TransferSpreadsheet Excel 2007 into Access 2003 - microsoft.public ... How can I TransferSpreadsheet Excel 2007 into Access 2003? This does not work ... action - microsoft ... TransferSpreadsheet Error, Access 2003 to Excel 2007. - microsoft ...I had this problem & it appears to be a glitch. I have macros that execute TransferSpreadsheet and/or SendObject. You just have to go into the Action part and re-set ... Problem with TransferSpreadsheet in Access 2007 - microsoft.public ...TransferSpreadsheet Excel 2007 into Access 2003 - microsoft.public ... Problem with TransferSpreadsheet in Access 2007 - microsoft.public ... TransferSpreadsheet Excel ... Adding Today's Date to an Excel Filename using TransferSpreadsheet ...TransferSpreadsheet Excel 2007 into Access 2003 - microsoft.public ... Adding Today's Date to an Excel Filename using TransferSpreadsheet ... TransferSpreadsheet Excel ... DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8 ...Is it possible to append the data from excel file to a table in Access in such a way that excel file does not have a field's name? When I run this transferspreadsheet ... Using TransferSpreadsheet Macro to import a single sheet from exce ...TransferSpreadsheet Excel 2007 into Access 2003 - microsoft.public ... Using TransferSpreadsheet Macro to import a single sheet from exce ... TransferSpreadsheet Excel ... TransferSpreadsheet Issue - microsoft.public.access.formscoding ...TransferSpreadsheet Error, Access 2003 to Excel 2007. - microsoft ... Here's ... to import an excel spreadsheet into a Access Table. It works OK with Office 2003 and Access ... Export query to Excel fails - microsoft.public.accessAccess 2007 on WinXP When export query results to Excel, receive following ... Sorry, I am on Access 2003. I do ... of query result to Excel with TransferSpreadsheet into ... Format Excel Sheet after DoCmd.TransferSpreadsheet - microsoft ...... query out to excel... DoCmd.TransferSpreadsheet ... constants -- built into VBA code by Microsoft -- that look like variables; in EXCEL they start with xl, in ACCESS ... Answer : TransferSpreadsheet Excel 2007 into Access 2003TransferSpreadsheet Excel 2007 into Access 2003 - answer - How can I TransferSpreadsheet Excel 2007 into Access 2003? This does not work: DoCmd.TransferSpreadsheet ... Excel - Transferspreadsheet Method With Access 2003 & Excel 2007 ...Transferspreadsheet Method With Access 2003 & Excel 2007 - Hi I have been ... used the TransferSpreadsheet method to export some queries from my Access Db into excel, this is ... TransferSpreadsheet Excel 2007 into Access 2003 DataBaseHow can I TransferSpreadsheet Excel 2007 into Access 2003 This does not work: DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, tblSomeData, C: \Data TransferSpreadsheet Method [Access 2003 VBA Language Reference]TransferSpreadsheet Method [Access 2003 VBA Language Reference] ... the Lotus spreadsheet Newemps.wk3 into the Microsoft Access ... Office 2007 developer map; SDKs and ... TransferSpreadsheet Excel 2007 into Access 2003 - microsoft.public ...How can I TransferSpreadsheet Excel 2007 into Access 2003? This does not work: DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblSomeData... 7/24/2012 11:22:20 AM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
71 followers. 