Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to OLEDB provider using ODBC
Message
From
14/03/2012 16:44:20
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:
01538366
Views:
95
>>>>>>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?
>>
>>Maybe so. I would think both 32 & 64-bit drivers would be in the x64 version, but perhaps they were kept separate.
>
>Downloaded that version, but it doesn't install on 64 bit Office. Where else can I get 32 bit version of this driver?

Sorry, I don't know. One of those downloads should have worked. You could try the Office installation and see if there is an option to add the drivers. You might also check that your anti-virus isn't removing the files.
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