data loading tool for mysql?

Question

i have a .xls file with some data requirements, that should be inserted into a mysql table in my DB, but the requirement list has nearly 400 rows and manualy inserting it is a nightmare, any tool that can import the data to mysql table, based on the constraints in my .xls doc.
-any help would be appreciated.

Answer 1

From my knowledge there is no easy way to import from EXCEL (file format), but you can go easy with TXT or CSV format



1, Open and Save the excel file (which has the data) into on CSV file.

2, open that CSV file and check if the data saved in to the CSV properly with COMMA sapaerated.

3 . connect to MySQL as root

4.. create a table in the connected database with the number of fields matching the CSV file

5. execute the below command



LOAD DATA INFILE 'C:/data.txt' into table table1 FIELDS TERMINATED BY ','



Note: use the forward slash for path saperator.

Answer 2

Oracle is a lot versatile than MySQL. Oracle can run and guard extra transactions than MysQL. Oracle could be extra useful in case you have got various db utilization. i've got used MySQL. Oracle is costly, however they got here out with Oracle loose version to entice MySQL shoppers.

Answer 3

you can use import tool in phpmyadmin

or in excel save as CSV file then import using import tool in phpmyadmin