Mysql & Excel

[scialom]

Hi

Can I connect from an excel sheet to mysql db?

If yes how?

Thanks,
Assaf

[bastien]

Not sure what you mean here. Can up code an Excel sheet to connect to a mysql db? Yes, use vBA and code behind the sheet.

If you are looking to export some mysql data thru php, then there are other options

1. [man]COM[/man]
2. write a script to create a CSV file, which excel can read, no problem
3. Export html to excel thru the content headers with PHP

[scialom]

Thanks,

But what I need is from the excel to make sql query to the db. Is it possible?

Assaf

[bastien]

Yes, I said that it is possible. You will need to use VBA to do, but its very possible.