Hey all,
I am having an issue with reading the correct schema, and subsequent data, out of DBF FoxPro files. I can register the DB connection, and it sees the correct folder structure from the FoxPro directory (this was set up in the ODBC Data Source Admin), but when working in Talend, there is no schema info for the tables and more importantly, no data can be read out.
Some more info:
These are posts from 2007-2011 related to this topic, but none of the solutions worked for me...
Reading Visual FoxPro DBF Data Overall guide on connecting to FoxPro Extract Data from DBF Files IMPORTANT:
The newest Visual FoxPro driver is an OLEDB driver, Microsoft is no longer supporting the dev of the generic ODBC driver. However, my organization has a "deployment package" for VFP and this is bundled with the "old" ODBC driver. I cannot update this without breaking other processes. Therefore, I am *not* using the most up-to-date VFP driver - although there is no guarantee that this driver would fix the issue.
Does anyone have a working solution, or any suggestions?