|
Introduction |
|
Using SQL File Import |
|
|
Select source data
On
this page, enter a description for the task so that you can
identify the purpose of the task. The description is also displayed
on the home page.
Next, select the source data type. If you are only importing files
into your database, select the Files
item.
SQL File Import will then look in the folders you entered to find
matching files, and import those files into your database. If you
need to import additional details into your database, for e.g. the
file name, you can still do so by using scripts. See the
Demo
1 sample
task on how to perform this.
If you need to import files and other data into your database, you
can prepare a comma-separated values (CSV) file (using semi-colons
as the value separator), and use that file as the source for the
upload. You can also prepare the data in an Excel spreadsheet.
Depending on the option you choose, select the appropriate item in
the source data type option, and enter the name of the CSV of Excel
file.
If
your CSV files uses a different delimiter, enter this delimiter
symbol in the text box so that SQL File Import parses the CSV file
correctly.
For CSV and Excel source files, you can choose to delete or move
the file once the import process has completed.
If you
choose to move the file to a folder, enter the folder name in the
area below:
|