stevegray
4Penny.net
Points: 53175

8/31/2020 9:10:35 AM

SQL Bulk Insert

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Came across a requirement today to import a csv file into SQL. As usual, I want the quickest way to do this.

The text file looks like this (notice the inconsistent quotes):

1,"steve",123
2,tom,456
3,"jerry",789

Details below

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3