sql.request help

[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?

 

[Chris Leonard]

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?

Where is the server ? is it on the web somewhere ? if so try a webquery

 

[Shutter]

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.)

 

[Chris Leonard]

Try this site.

http://www.connectionstrings.com/

Holds loads of connection strings

HTH

Chris

 

[firstwob]

Try this sit
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/html/sec41.as
I tried using this function to access an SQL table to look up a par
number in an adjacent cell and then return the description. It worke
fine as long as the part number was numeric. If it was alpha-numeric i
returned an error. Never could get it to work. Good luck