Lets say you get a Microsoft Excel file containing the following information:

image

 

If you want to import these record in a SQL table, just save the excel file as CSV.

Then upload it to http://www.convertcsvtomysql.com/

 

 

image

 

This will generate the following SQL script:

CREATE TABLE IF NOT EXISTS ‘product’
(
‘name’ VARCHAR(255) NOT NULL,
‘description’ VARCHAR(255) NOT NULL
)

INSERT INTO ‘product’ VALUES
(‘Car’, ‘This is the car description’),
(‘Bike’, ‘This is the bike description’),
(‘Bus’, ‘This is the bus description’);

 

Remove the "create table" peace if your table already exists.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.