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?

asked 08 Sep, 06:05

Siger%20Matt's gravatar image

Siger Matt
3.2k496997
accept rate: 13%

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

Very wild guessing...

(08 Sep, 10:21) Volker Barth
Replies hidden

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

(08 Sep, 12:55) Siger Matt
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×90
×9
×1

question asked: 08 Sep, 06:05

question was seen: 54 times

last updated: 08 Sep, 12:55