Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL queries on the Mac
9 views
Skip to first unread message
Maury Markowitz
Apr 27, 2012, 2:41:40 PM4/27/12
to
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?
0 new messages