| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mysql popup | Excel Discussion (Misc queries) | |||
| xls to mysql | Excel Discussion (Misc queries) | |||
| How can I import data from a mysql database into excel | Excel Discussion (Misc queries) | |||
| Formatting datetime problems importing data from mysql db | Excel Discussion (Misc queries) | |||
| Import MySQL data to Excel | Excel Discussion (Misc queries) | |||
![Amedee Van Gasse[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
