Import MySQL data to Excel
 

I would like to have a local Excel worksheet go out to a MySQL database
on a webserver and get data. I've seen how you can do web queries, but
these don't work with any site that requires authentication. I've also
seen the ODBC engine, but this only seems to work on local databases.
Does anyone know how I can link a worksheet to a MySQL database?


--
mbeyer
------------------------------------------------------------------------
mbeyer's Profile: http://www.excelforum.com/member.php...o&userid=29230
View this thread: http://www.excelforum.com/showthread...hreadid=489532