MySQL - Excel

[miffe]

Is it possible to run query's from MS Excel on 'PC1' being on the same network LAN as 'PC_Server' which has Apache, MySQL and Php with MySQL Extensions installed?

If so, how can I run the query and produce results?

Thanks a lot,
Miffe.

 

[MarkAndrews]

Data > Get External data?

 

[Rixn]

Is it possible to do the reverse - send cell data to the MySql db?

 

[Exceljeanie]

Hi,
a wonderfull job for VB and MySql you find here:
(You can use the class in VBA)

http://www.icarz.com/mysql/

Peter

 

[Rixn]

ty, i'll try!