FoxPro Uploads through SSMS Import Wizard on 64 bit server

[thesierras]

We have SQL Server 2014 running on a 64 bit server. When using SSMS / Object Explorer / DatabaseName / Tasks / Import Data, I select the Visual FoxPro driver for my data source and I receive an error as soon as I select the properties button to locate my file. The same happens when I do Export Data to a FoxPro table. I'm thinking that this may be caused by the the VFP OLEDB driver being a 32 bit driver. Any suggestions for a good way to fix this. The solution needs to be something that can easily be used dynamically as opposed to requiring hard coded values and paths.

 

[DSummZZZ]

32 bit could be this issue, not sure. That driver hasn't been updated in eons.
Maybe this link would help?

http://tinyurl.com/o9sdmxm

-Dave Summers-

Even more Fox stuff at:

http://www.dave-summers.net/foxprolinks.htm

 

[Olaf Doschke]

The ODBC driver hasn't been updated in even more eons. The import wizard seeems to use a feature unavailable in VFP OLEDB, but ODBC is not a solution, unless your data is in legacy dbfs.

Bye, Olaf.

 

[RFanslow]

I have this exact same issue for moving data both up and back....
there are a few writeups, but i have not found any of them to be successful

the only solution is a remove connection from foxpro

as a side note i do have the 64 bit Foxpro which i am told does have a 64 bit driver, but i have yet to install it on a machine to toy with

Fanz