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