Visual FoxPro as a Remote Server via OLE

[former_SQLA_member1694868]

I am attempting to bring the contents of a Visual FoxPro database into SA 17.0.4.2053.

I have installed VFP 9 using the CD provided by the client and downloaded the OLE DB provider for Microsoft Visual FoxPro as Microsoft says the ODBC driver is no longer available / supported.

I was able to connect to the database and read the data in Excel 2007 using the OLE DB provider, and I have been told that changing the dbf extension of these older files to xls allows Excel to open them up correctly.

My question is what is the best way to get this data into tables in SQL Anywhere?

I have used the remote server feature before, but only with ODBC connections. Can an OLE connection be used with a remote server and if so how?

[VolkerBarth]

Have you tried with a generic ODBC server class with an Excel ODBC driver, when Excel can open FoxPro files?

Very wild guessing...

[former_SQLA_member1694868]

Seemed promising, but I get "External Table is not in the expected format."

[former_SQLA_member1694868]

Still interested if OLE is an option, but to finish the story I ended up exporting the VFP data to text and then importing the text files into SA 17.