on 2017 Sep 08 7:05 AM
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?
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.