Hi techyv,
How can I perform excel insert mysql? I made a database draft in Microsoft excel application. I want automatically transfer my excel files in to mysql database server. Would it be possible for me to perform this kind of tasks? The company needs the database as soon as possible and I have to find the best solution.
Hoping for your help and kind consideration.
Hi Kathryn,
It is possible to insert excel file into MySQL. Save your excel file into CSV file using the ‘Save as’ command under ‘File’. Open you CSV file with notepad see what the look of the file is and what delimiter is used. Open MySQL application then type the following command:
LOAD DATA LOCAL INFILE ‘C:\temp\yourCSVfile’ INTO TABLE database.table FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘rn’ (field1, field2);
There you are done with the process. Hope this will help you.
Regards
Hello Kathryn,
You can as well try using mysqlimport utility, which is actually a command line alternative to LOAD DATA INFILE statement.
So your process would be –
Once again, it is important to create the tables otherwise mysqlimport statements would result in error.
Regards
Mclean
