Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Import CSV File Into SQL Server Using Bulk Insert
CREATE TABLE CSVTest (ID INT, FirstName VARCHAR(40), LastName VARCHAR(40), BirthDate SMALLDATETIME) GO BULK INSERT CSVTest FROM 'c:\csvtest.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO --Check the content of the table. SELECT * FROM CSVTest GO --Drop the table to clean up database. DROP TABLE CSVTest GO
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Allocations Check
Elena-Tests
TRANHOANGLONG
Campeonato 3 bilhoes
IOU2
Libros
SQL HW 1 Appline
20181CSE0041
DBMS ca2
Quiz
stackse - search stackoverflow differently
Please log in to post a comment.