View Schema with *.DBF FoxPro tables?

One Star

View Schema with *.DBF FoxPro tables?

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
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?
Four Stars

Re: View Schema with *.DBF FoxPro tables?

Have you checked this working example at
One Star

Re: View Schema with *.DBF FoxPro tables?

Thank you for your response;
The tDBInput component requires
...relevant DBMSs' ODBC drivers should be installed and the corresponding ODBC connections should be configured...

The drivers and subsequent config are exactly my issue.
Any other suggestions for a DBF/FoxPro-specific solution?

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


APIs for Dummies

View this on-demand webinar about APIs....

Watch Now