sql.request help

  • Thread starter Thread starter Shutter
  • Start date Start date
S

Shutter

Hi there,

I am trying to look up data from a local (win) mysql database from directly
in a cell. The help files came up with the sql.request function. Can
anybody help with the correct connection parameters to use with this
function to connect to a mysql server?
 
I am trying to look up data from a local (win) mysql database from
directly
in a cell. The help files came up with the sql.request function. Can
anybody help with the correct connection parameters to use with this
function to connect to a mysql server?
Click to expand...
Where is the server ? is it on the web somewhere ? if so try a webquery
 
Thanks for the suggestion...
There is one server running on the machine Excel is running on (my laptop)
and also another at my ISP. I use queries a lot to bring data into a
spreadsheet which is great. It would be very useful too to have the ability
to use sql to populate a single cell with data from a mySql table via ODBC.
Every time I try the sql.request function I cannot get it to connect.
Presumably this is because I'm using the wrong connect parameters. Help
file gives examples for access and oracle but no other db's. (The info is
not on web pages at all.)
 
Back
Top