Exporting from Excel to MySQL

Question

I have an Excel file in which i have 50 questions i want to include for a questionnaire in a java applet. The answers for this questionnaire are to be stored in a MySQL database i have created.

Is there any way i can select all (or a subset) of the questions from my Excel file and place them into fields (that i choose) in the MySQL table?

I have looked around and load data infile sounds like an options that works but i would like to select which questions and where to place them. Could anyone point me in the right direction? Or should i simply copy and paste?

Any help would be great!

Solution

Save your Excel data in the CSV format and then import it in MySQL using the LOAD DATA command.

Information on the later can, e.g., found here:

• MySql importing from CSV
• http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Comments

[Julian Moreno]

Page Not Found.