Friday, June 03, 2011 8:21 AM
my client has just upgraded to Office 2010 64 bit on a 2008 64 bit server. They have a VFP backend and many analysis spreadsheets in Excel using a DSN through the 32 bit OLEDB driver (using the 32 bit DSN manager) pointing to the VFP DBF file.
Excel 2010 64 bit can not connect to VFP using the existing VFPOLEDB.dll driver (found here http://www.microsoft.com/downloads/en/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4). I've been searching but only found a likely solution in the Access Database Engine 2010 Redistributable (see http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D).
Before playing with their production server, is there any definitive answer to the question of the existence of a 64 bit VFP driver (or a means of accessing VFP from Excel 2010 64 bit?
Your answers will be greatly appreciated!
Friday, June 03, 2011 10:12 AMModerator
Microsoft VFP 64 bit driver does not exist. 64 bit Access engine can read dBase III/IV DBF files only.
You may try Sybase Advantage Server which has 64 bit VFP drivers included even in trial version (http://www.sybase.com/products/databasemanagement/advantagedatabaseserver)
Monday, June 06, 2011 12:36 PM
Many thanks for your help Pavel. I'm a little dismayed for my client - perhaps it is time for an upgrade to something a little more recent... like chalk on slate tablets...!
It would be nice to be able to download just the driver without having to install Advantage Server... any ideas?
Cheers and many thanks once again,