Import data from TSV to SQL Server via command line on Windows

by

Want to import data from TSV file to SQL Server via command line on Windows?

Using mssql-cmd, you can import data from TSV file to SQL Server easily and fast, no need to program.

Here you can download mssql-cmd Windows version.

Import data from TSV file to SQL Server via command line on Windows

1. In interactive mode:

mssql-cmd> load loadtype=replace
      > table=media_messages 
      > datafile=f:\media_messages.tsv 
      > delimiter=TAB 
      > quote=" 
      > header=y;

2. In batch mode:

mssql-cmd dsn="pan:withdata@192.168.0.102/test" task=load loadtype=replace table=media_messages datafile=f:\media_messages.tsv delimiter=TAB quote=" header=y quit=y

“loadtype=replace” will delete all data in table before inserting.

See parameters detail.


More about mssql-cmd – the tool to import data from TSV file to SQL Server via command line on Windows/Linux/MacOS

30-day free trial Download mssql-cmdUS$49.95 Buy mssql-cmd