How to import data from MS excel and paste into MYSQL database? Which language is easier and faster to complete this task?
If you can safely represent everything in CSV format (just export from Excel), you only need one command:
LOAD DATA INFILE '/tmp/coolfile.txt' INTO TABLE coolTable;
I would use a Swiss army data manipulation knife in the window world:
MS Access
Import an Excel sheet into an Access table and export the table through ODBC to MySQL
Not a programming issue, the fastest method I would suggest is to export data from Excel to a CSV file and then import it into MySQL using the LOAD DATA INFILE command.
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
On Windows, you can use the phpMyAdmin import function. It has many options, including import from Microsoft Excel!
import