Can someone post an example of some vba that you might use to do a simple odbc query to informix and return the data to an excel spreadsheet?
I am having particular trouble with the connection string...I can get this to work using MSQuery, Excel and Informix, but I want to cut the MSQuery piece out so I can change the sql statement dynamically on the spreadsheet (creat a simple frontend for users to enter criteria).
Appreciate any brain power!
Running infomix on aix if it matters - version 9.2 and using the intersolv odbc drivers.
I am having particular trouble with the connection string...I can get this to work using MSQuery, Excel and Informix, but I want to cut the MSQuery piece out so I can change the sql statement dynamically on the spreadsheet (creat a simple frontend for users to enter criteria).
Appreciate any brain power!
Running infomix on aix if it matters - version 9.2 and using the intersolv odbc drivers.