Import CSV Data Into MsSql Server Using Bulk Insert Method

Import CSV Data or File Into MsSql Server Using Sql Bulk Insert Method in Asp.Net. Some time while developing applications using sql server we need to import or insert data into database from data files or csv files.

For this we can use bulk insert method to insert data from csv file to sql server .

1. create a csv file with some data in it like


amit,noida,26

sharad,noida,26

Shobhit,Delhi,25

Now run the following script to load data from this csv file into Database

--Temp table to store the data
CREATE TABLE Test
(
Name VARCHAR(50),
City VARCHAR(50),
Age INT
)
GO

--Bulk insert into Test
BULK INSERT Test
FROM 'C:\test.csv'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR = '\n'
)
GO

--Get all data from Test
SELECT *
FROM Test
GO

--Drop the temp table
DROP TABLE Test
GO

Other SQL Server articles:
1.Import/Export Excel Data into Sql Server using SqlBulkCopy-ASP.NET
2.Install configure and troubleshooting sql server reporting services 2005
3.Ms sql server bulk insert method to import bulk csv data into database
4.Combine Multiple Records Comma Separated In One Column MSSQL
6.Disable browser back button functionality using javascript in ASP.NET
7.Method error 500 / 12031 in implementing ajax cascadingdropdown extender
8.Unable to attach binding handle invalid error in visual studio 2005 while debugging
9.The backup set holds a backup of a database other than the existing database-Sql Server Error 3154

Tweet

If you like this post than join us or share