Import data from TSV file to SQL Server without programming

Shiji Pan

8 years ago

Want to import data from TSV file to SQL Server ?

Using FileToDB, a native GUI tool, you can import data from TSV file to SQL Server easily and fast.

Step by step, just a few mouse clicks.
Avoid uploading big TSV file(s) to online services.
Support large TSV files (big than 4GB).

Support Windows, Linux, macOS.

Download FileToDB

Here’s how to.

Example
Import
Save/load session
Run in command line
Run as scheduled task

Example of importing TSV to SQL Server

Example source TSV file

After converting, data in SQL Server table

Import data from TSV file to SQL Server

Choose SQL Server and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select the “TSV” file type.

then show the wizard.

1. Open a TSV file.

Support multiple TSV file encodings: ANSI, UTF-8, UTF-8BOM, UCS-2LE (Unicode Little Endian), UCS-2BE (Unicode Big Endian), CP1250 (Central European), CP1251 (Cyrillic), CP1252 (Western European), CP1253 (Greek), CP1254 (Turkish ), CP1255 (Hebrew), CP1256 (Arabic), CP1257 (Baltic), CP1258 (Vietnamese), CP437 (United States), CP850 (Western European), CP852 (Central European), CP866 (Cyrillic), CP874 (Thai), CP932 (Japanese), CP936 (Chinese Simplified), CP949 (Korean), CP950 (Chinese Traditional), ISO-8859-1 (Western European), ISO-8859-2 (Central European), ISO-8859-15 (Latin 9), KOI-8 (Cyrillic), Macintosh (Western European).

2. Select a SQL Server table and config fields.

3. Preview data.

4. Import TSV data to SQL Server.

View imported data in SQL Server table

Save/load session of importing TSV to SQL Server

You can save/load session to run “TSV to SQL Server” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

then show the wizard form, click a few “Next” to import TSV to SQL Server.

Run in command line for importing TSV to SQL Server

You can run “TSV to SQL Server” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

The “Save & Make Batch File” form shows.

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\FileToDB"
FileToDB task="C:\Users\pansh\Documents\test.ldr" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Run as scheduled task for importing TSV to SQL Server

You can run “TSV to SQL Server” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.