Home
SQL File Import online help Prev Page Prev Page
Introduction
About SQL File Import
Version history
Contact us
Supported database engines
Using SQL File Import
Home page
Task Wizard
Select source data
Files as source data
CSV source data files
Excel source data files
Enter file search patterns
Connect to database
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
Database scripts
Select table to upload into
Map data to table columns
Review script results
Transaction options
Logging options
Finalise
Run task
Scheduling a task
Options
Scripting
Global variables
OnBeforeUpload function
OnAfterUpload function
Support functions
Data functions
Log functions
String functions
Date and time functions
Date-Time format strings
File functions

Connect to database

Enter the details needed to connect to the database which you want to import the files and data into.

wizard03  

The current version of SQL File Import supports the following databases:

· Firebird 2.x, 1.x  
· MySQL 5.5, 5.1, 5.0, 4.1, 4.0, and 3.23  
· Oracle 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle Express Edition 11g and 10g  
· PostgreSQL 7.1 up to 9.1  
· SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7  
· SQL Server Compact 4.0, 3.5, 3.1  
· SQL Azure  
· SQLite 3.0 and higher  
· ODBC supported databases