New leafs on an old tree

used in BOA project
http://www.prophetsuite.com/
http://www.activelogix.com/ (by Ex Tridium developer)

From Excel to MySql:
1. Export your data from Excel to a flat.csv file.
2. Put that flat.csv in C:\ (just for convenience)
3. Launch mysql command or use MySQL Quer Browser:
LOAD DATA LOCAL INFILE 'C:\\flat.csv' INTO TABLE tblTest FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n'
(field1, field2)

If you have an extra character after the field, use this:
LINES TERMINATED BY '\r\n'

If you don't want to have the column names imported, open the .csv file with NOTEPAD and delete them or use IGNORE ROW in the SQL

Alternative steps:
1. create a ODBC connection to the destination MySQL database.
2. Open MS Access and create a new access database.
3. Import the excel data creating a new table.
4. Export the new table just created selecting "Database ODBC()" from file Type list.
5. Select the ODBC connection related to the destination MySQL database

http://www.straxx.com/excel/password.html