upload data from your folders, CSV definitions, or Excel spreadsheets
•point-and-click interface to map columns•reduce storage costs and increase security using compression and encryption options•supports Access, Firebird, MySQL, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources
Reduce storage costs, increase security
Point and click to map columns
Use folders, CSV or Excel files as source data
Set up periodic upload tasks
Scripting engine to transform source data
Get timely notifications
For simple import tasks, select the folders containing the files. If you need to upload additional data, simply prepare the data in CSV or Excel files, and SQL File Import will upload the data accordingly.
Simply point and click to map source data to table columns. Sample tasks are provided to give you a head start to complete the most common tasks.
Need to pre-process or transform the source data? A scripting engine provides additional flexibility in preparing your source data prior to upload.
Using the scripting engine, you can compress your files prior to upload. Compress using the zip format for wide compatibility. For even better compression, use the 7-zip option. Either way, you can still encrypt your files for added security.
SQL File Import uses the Windows Task Scheduler to run your scheduled tasks, avoiding the need to use different database scheduling agents. Requires the Professional Edition.
Email notifications inform you of task results. Or you can choose to receive email notifications only when errors occur.