M
Maury Markowitz
I'm moving from the PC side where I was "guru level" to the Mac where
I am "noobie level" and I'd like to bootstrap.
My VBA on the PC tended to be based on SQL queries which were built up
in code as strings that were then sent to the server using ADODB. I
would then take the results and massage them in code before returning
the results.
It appears Mac Excel does not have ADODB, and Jim's articles suggest
the closest analog is MSQuery. If so, I'd still like to build
everything up in code. Jim has some Web Query links, but I'm too noob
to parse them into SQL.
So does anyone have some examples of building the SQL in VBA, sending
it to the ODBC DSN, and then retrieving the results?
I am "noobie level" and I'd like to bootstrap.
My VBA on the PC tended to be based on SQL queries which were built up
in code as strings that were then sent to the server using ADODB. I
would then take the results and massage them in code before returning
the results.
It appears Mac Excel does not have ADODB, and Jim's articles suggest
the closest analog is MSQuery. If so, I'd still like to build
everything up in code. Jim has some Web Query links, but I'm too noob
to parse them into SQL.
So does anyone have some examples of building the SQL in VBA, sending
it to the ODBC DSN, and then retrieving the results?