Withdata Software

TxtToSql - SQL Server import Csv (Txt) »

Download TxtToSql Free Trial »     Buy TxtToSql Now »

How to batch import txt (csv) data to SQL Server from a folder

Click "Wizard - Import From Folder" at task dialog.

Batch import Csv (Txt) data To SQL Server - task window

then show the wizard.

1. Select a folder.

Batch import Csv (Txt) data To SQL Server - select a folder

2. Select a table and config fields.

Batch import Csv (Txt) data To SQL Server - select table

3. Preview data.

Batch import Csv (Txt) data To SQL Server - preview

4. Import.

Batch import Csv (Txt) data To SQL Server - import data

For repeatable task, you can click "Save Session" button to save config, then run it next time. see also: Save and load session.