Skip to content

Instantly share code, notes, and snippets.

@sbealer

sbealer/import csv into SQL Server no format file.sql

Last active May 18, 2017 21:48
Show Gist options
  • Save sbealer/8663a0cbc896ade44ce55ea1ef844aa1 to your computer and use it in GitHub Desktop.
Save sbealer/8663a0cbc896ade44ce55ea1ef844aa1 to your computer and use it in GitHub Desktop.
Download ZIP
Import csv into SQL Server without need of format file
Raw
import csv into SQL Server no format file.sql
INSERT INTO [YOURLINKEDSERVER].[YOURDB].[DBO].YOURTABLE
SELECT
*
,cast('2017-05-20' as date)
FROM OPENROWSET('MSDASQL'
, 'Driver={Microsoft Access Text Driver (*.txt, *.csv)};
DBQ=C:\first_directory\second_directory\'
, 'select * from "your_file.csv"')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment