DAO for Excel 2010 import

NobodysPerfect · #1 02-27-2014, 09:45 AM

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")

I often used (and still use) it. Source: http://word.mvps.org/faqs/interdev/xltowordwithdao.htm

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")

With Excel 14 this connection fails with an Installable ISAM errror. Same if I try "Excel 12.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

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