Import CSV into MSSQL database

Use the MSSQL command following, to import the CSV file into the Microsoft SQL (MSSQL) table

MSSQL command:

BULK
INSERT [dbo].[TABLE_NAME]FROM 'c:\files.csv'WITH(FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')GO

Windows 2008 R2 can't see the created ODBC connection from ODBC manager

32-bit ODBC on Windows Server 2008 R2

Heterogeneous data access requires having the right drivers. If you have to use 32-bit ODBC drivers, you won’t find then when you start the Microsoft ODBC Administrator because it is 64-bit.
The 32-bit ODBC Administrator is found here: C:\Windows\SysWOW64\odbcad32.exe

You might want to make a shortcut for it to make it easy to find. You’ll need to use it when make 32-bit ODBC data connections.