Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to OLEDB provider using ODBC
Message
 
 
To
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:
01538354
Views:
70
>>>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.

No, the file is not there. I just run the AccessDatabaseEngine_64 file which I downloaded. Should I also get the one without 64?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform