How to Import a CSV

SQL Tutorial Home

If you have a CSV file you can import into a table using the BULK INSERT command of MS-SQL Server as seen in the following example:

-- The file and the table have the same quantity of columns
Bulk insert sales.orders
From '\\system\diskz\sales\data\orders.csv'
With ( format='CSV');

IN THIS PAGE