Import data from mysql

[Shaun]

Hi,

Is it possible to get Excel to import data from a mysql database on a web
server?

Thanks for your help

 

[Tom Ogilvy]

Look at Data=>Get External Data.

 

[Shaun]

Thanks,

I managed to get that far, I was after a little help with the settings
here...

 

[Tom Ogilvy]

Turn on the macro recorder while you do it manually. If you have the
ODBC/OLE DB drivers to support accessing MySQL, then you should be set. If
not, perhaps check their web site.

Another source off information:

http://www.able-consulting.com/ADO_Conn.htm