27 June, 2013
0 Comments
1 category
Lets say you get a Microsoft Excel file containing the following information:
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/
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.
Tags: ExcelSQL Server
Category: Uncategorized