Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to OLEDB provider using ODBC
Message
From
14/03/2012 15:38:54
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01535618
Message ID:
01538353
Views:
68
>>I have Office 2010 x64 too, and it works fine for me. Perhaps there was an option to install the drivers when I originally installed Office. I don't remember. Try this: Create an empty file with a .UDL extension, double-click on it and look at the Providers tab. You should see Microsoft Office 12.0 Access Database Engine OLE DB Provider. If it's not there, download the drivers from http://www.microsoft.com/download/en/details.aspx?id=13255.
>>
>It is there. What should I do on the Connection tab? This is what it shows (see attached). I try to put xls file name in the Data Source (with the path) and got an error.
>
>I also just re-installed this driver and I am still getting errors.

Hmmmm... I don't know. Do you see C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEOLEDB.DLL on your system? Notice that it is in the 32-bit (x86) folder. If it's there, maybe try to register it.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform