CSV files to MSSQL Converter is a tool to Convert, Migrate data from
Excel XLS / XLSX / CSV /
Delimited Text Files to MS SQL Server Database or from MSSQL to CSV / Delimited
Text Files or Fixed width files. You can convert multiple files in one go to
MSSQL tables or convert multiple MSSQL tables to CSV files. While converting you
can map source columns to matching destination table columns, filter rows by
specifying WHERE conditions.
Creates tables with matching data types and widths and loads the data
without need to write a single piece of code
Transfer data in just few steps
Once executed, you can save the Session in a repository to run it again in future. You can run the Session again manually or you can also run the session from command line interface also. You can even schedule it to run at specific intervals and in built Scheduler will execute it automatically
All the sessions are stored in a repository. The Converter provides a user friendly interface to manage repository. Such as taking backup and/or restore repository from a previous backup. You can also create a new blank repository in case you need it.
Synchronizes EXCEL / CSV and MS SQL Server databases by Updating a row if a matching row exist in the target table. If the matching row does not exist it Inserts a new row in the target MSSQL table