First, you need 
and install TxtToSql.
TxtToSql is a tool to import CSV data to Sql Server database.
Using TxtToSql you can import CSV data to Sql Server easily and fast.
Wizard for importing txt (csv) data to Sql Server
Click “Wizard – Import From File” at task dialog.
then show the wizard.
1. Open a file.
2. Select a table and config fields.
3. Preview data.
4. Import.
For repeatable task, you can click “Save Session” button to save config, then run it next time. see also: Save and load session.
30-day free trial US$59.95 
CSV → SQL Server reference
Type mapping
| Value kind | in CSV | in SQL Server |
|---|---|---|
| Int | 1234 | int |
| Bigint | 9007199254740993 | bigint |
| Decimal | 1234.56 | decimal(p,s) |
| Float | 1.234e+10 | float |
| Text | quoted only when it contains a comma or a quote | nvarchar(n) |
| Long text | must be quoted; line breaks inside force multi-line records | nvarchar(max) |
| Date | 2026-09-18 | date |
| Datetime | 2026-09-18 14:30:00 | datetime2 |
| Binary | not representable - base64 or hex string | varbinary(max) |
| Boolean | TRUE / FALSE, or 1 / 0 depending on the writer | bit |
| JSON | the whole JSON value quoted, with internal quotes doubled | nvarchar(max) |
Dialect differences
CSV is a file format and SQL Server is a database server, so the target has to be told the types the file never carried – the rows below are where the two sides diverge.
| Property | in CSV | in SQL Server |
|---|---|---|
| port | — | 1433 |
| identifiers | Double quotes; a literal quote is doubled ("" ) | [square brackets] |
| row limit | — | SELECT TOP n |
| dates | Conventional text: 2026-09-18 or 2026-09-18 14:30:00 | datetime, datetime2, date, time |
| long text | — | nvarchar(max) |
| binary | Not supported | varbinary(max) |
| separator | Comma "," | — |
| encoding | No declaration - UTF-8 works only with a BOM | — |
| typing | None - every field is text | — |
| shape | Flat table, optional header row | Tables of rows and columns |
| ceiling | No formal limit; row count bounded by memory | — |
Command line
| Side | Command |
|---|---|
| SQL Server | bcp |
| SQL Server (load) | bcp, or BULK INSERT |
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.
