>Hi: I am both new to the idea of connecting VFP to other programs and flummoxed by it. I would like to be able to connect VFP to any of the following: postgreSQL, tableau or knime. I realize that ODBC or perhaps OLEDB should work; or, I could figure out how to write XLSX files that programs such as tableau and knime can presumably import. Which way should I proceed? Can some point me to a guide for using either ODBC or OLEDB. I have read every post I could find. I can see that others have figured out how to write to xlsx files. I would like to be able to prepare my tables in VFP because I have used it for so many years, I also wonder if OLEDB of ODBC can work when my installation of postgreSQL is 64 bits?
>Thank you,
>Steve

I think you can still get this book as an ebook: http://www.hentzenwerke.com/catalog/csvfp.htm. It's focused on using SQL Server, and it's old enough that it doesn't include cursoradapters, but the underlying idea of client-server will still be useful.

This pair of papers from Doug Hennig might be useful to you, too: http://doughennig.com/Papers/Pub/DataStrategiesIntro.pdf and http://doughennig.com/Papers/Pub/DataStrategiesAdvanced.pdf

Tamar