Import data from mysql
 

Hi,

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

Thanks for your help

Import data from mysql
 

Look at Data=Get External Data.

--
Regards,
Tom Ogilvy

"Shaun" wrote in message
...
Hi,

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

Thanks for your help

Import data from mysql
 

Thanks,

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


"Tom Ogilvy" wrote in message
...
Look at Data=Get External Data.

--
Regards,
Tom Ogilvy

"Shaun" wrote in message
...
Hi,

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

Thanks for your help

Import data from mysql
 

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



--
Regards,
Tom Ogilvy

"Shaun" wrote in message
...
Thanks,

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


"Tom Ogilvy" wrote in message
...
Look at Data=Get External Data.

--
Regards,
Tom Ogilvy

"Shaun" wrote in message
...
Hi,

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

Thanks for your help