>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

In my 20+ years on the forums it is the first time I see that very common "flummoxed" word. Why would you target native speakers only :( - luckily my Mac OSX and safari have the ability for an easy word lookup without making hops.

I would think in the context of postgreSQL and VFP:
postgreSQL has FDWs. Unfortunately AFAIK, there is no OLEDB FDW or VFP FDW. There is ODBC. Using Sybase ADS in between ODBC FDW might be one solution.

postgreSQL also can work with CSVs and xlsx (besides many other formats). But if you can export your data to such formats, then that means you can export to directly to postgreSQL or at worst to Sqlite (postgreSQL has SQLite FDW).

It would be much better to know your exact scenario. It might be even more feasible to use postgreSQL extensions (writing code in other languages like Go, V8 Javascript, Python, C ...).