 |
Introduction |
 |
Using SQL Select |
|
|
Export to SQLite
Click
on the Export
data sets to Excel button
( ) on the data sets toolbar. This will start the
export process.
Select the data sets you want to export. Each data set will be
exported to a different table. Thus, you need to give each table a
unique name. You can export both the active and locked data sets. You can view the data
contained in each data set by selecting the data set in the
Available
data sets list.
Enter
the database file name to export the data sets to. You can enter
the name of an existing SQLite database, or the name of a new
database. You also have the option of deleting any existing
database of the same name, and also existing tables of the same
name that you want to export the data sets into.
There are two SQLite options that help in speeding up the export
process, at the cost of data integrity. The Exclusive
access option
allows the SQLite engine to hold exclusive locks on the databases
for the duration of the export process. The Synchronous
off option
allows the SQLite engine to continue processing once it passes data
to the operating system, but it does not check if the data has been
safely written to disk.
SQL
Select will export the data sets to the SQLite database you named,
and report its progress. Once the export process has completed, you
can open the database by clicking on the Open
database button.
If you do not have any applications registered to open SQLite
databases, SQL Select will open the folder containing the database
file instead.
|