ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   importing data from MySQL (https://www.excelbanter.com/excel-programming/278467-importing-data-mysql.html)

Amedee Van Gasse[_2_]

importing data from MySQL
 
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.


--
Amedee

Phobos

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

P


"Amedee Van Gasse" wrote in
message . ..
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.


--
Amedee




merjet

importing data from MySQL
 
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/...odao/index.htm

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

HTH,
Merjet



Gys de Jongh

importing data from MySQL
 
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



"Amedee Van Gasse" wrote in
message . ..
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.


--
Amedee



Phobos

importing data from MySQL
 
merjet,

MySQL is an open source database:

http://www.mysql.com/

P


"merjet" wrote in message
news:tODeb.7639$%h1.6023@sccrnsc02...
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/...odao/index.htm

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

HTH,
Merjet






All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com