#1
|
|||
|
|||
DAO for Excel 2010 import
Hi,
For data exchange from Excel 2003 files to Word (no matter which Word version) the following code works fine. Code:
Set db = OpenDatabase("C:\Test\Book1.xls", False, False, "Excel 8.0") But I completely fail when trying to use it with Excel 2010. Code:
Set db = OpenDatabase("C:\Test\Book1.xlsx", False, False, "Excel 14.0") Conrol Panel > ODBC driver information says "MS Excel Driver (xls, xlsx, ...)" is installed. An idea what's going wrong here? I'd really like to continue importing data this way ... Thx NP |
#2
|
||||
|
||||
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi,
that's one of the first articels I read. I re-registered the "Regsvr32.exe" file, successfully. But no change at all - works fine for Excel 8 but same ISAM error with Excel 12 or 14. Yesterday I spent googling and reading for hours and it seems to be a quite common problem. But knowing this does not really help solving the problem .. Any other idea? NP |
#4
|
||||
|
||||
Form searching around it looks like the DAO approach isn't supported for the xml format used by Office 2007 & later. Accordingly, you'll need to use one of the newer methods.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks so much. Maybe a "Works with file versions < 12 only" hint would be usefull on the above mentioned site?
Will use ADO instead - and change my macros using DAO . Cheers NP |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import Excel spreadsheet calendar data into Outlook 2010 | davesp | Outlook | 0 | 09-30-2013 09:26 AM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |
import labels from excel | tactical | Mail Merge | 3 | 05-29-2012 04:03 PM |
Import Pics and Excel Data into PP? | jawillyams | PowerPoint | 0 | 03-13-2011 01:03 PM |
Can't import home adresses in outlook 2010 from excel named ranges | eekie | Outlook | 0 | 05-14-2010 02:04 PM |