|
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? |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 08 Sep '17, 06:05
question was seen: 1,475 times
last updated: 08 Jan '18, 09:49
Have you tried with a generic ODBC server class with an Excel ODBC driver, when Excel can open FoxPro files?
Very wild guessing...
Seemed promising, but I get "External Table is not in the expected format."
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.