Import CSV rows with 2000 records from node into SQL Server
181
February 06, 2018, at 2:03 PM
I am using exceljs (https://www.npmjs.com/package/exceljs) node package to read excel file.
I am looking for fast import csv with 2000 records into SQL Server.
Table:
User [Id PK]
Role [UserId FK]
Unit [UserId FK]
Excel file:
UserName Role Unit
Jack 1 Unit1
Answer 1
@Furqan, did you try executing BULK INSERT command to import CSV file contents into SQL Server database table
Here is sample target table
create table UploadTable (
[User] varchar(100),
[Role] varchar(100),
Unit varchar(100)
)
After you create your table try following SQL command
BULK INSERT UploadTable FROM 'c:\kodyaz\upload.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '0x0A'
)
-
05:30
-
04:00
-
00:00
-
10:30
-
9:10
-
07:40
Firebase Cloud Functions: PubSub, "res.on is not a function"
-
04:00
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
-
9:20
-
7:40
POPULAR ONLINE
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 111357 visits
- search for elements in a list 111041 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 98801 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 96299 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 92491 visits
- NetBeans IDE - ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver 62013 visits
- Adding methods to es6 child class 22362 visits
