importing data from MySQL

[Amedee Van Gasse]

Is it possible to import data from MySQL into Excel?
Also, is it possible to import Linux log files into Excel? Will there be no
CR/CRLF issues?

And can I update data in MySQL using Excel?

Can all this be done with something like ADO?

websites with clear examples would be appreciated.

 

[Phobos]

I don't know, but you might search the web for "myODBC".

P

 

[merjet]

Is it possible to import data from MySQL into Excel?

Not sure what you mean by MySQL, but see the examples at:
http://www.erlandsendata.no/english/vba/adodao/index.htm

You might also use the menu Data | Import External Data.

HTH,
Merjet

 

[Gys de Jongh]

Hi,

You can use ADO en ODBC to transfer data between Excel and MySQL
Here is a very nice project :

http://thelabwiz.home.mindspring.com/mysql.html

hth
Gys

 

[Phobos]

merjet,

MySQL is an open source database:

http://www.mysql.com/

P