Translate into your language!

Export as SQL File


This function lets you export data from Lotto Sorcerer into a SQL formatted text file. This is intended for importing the data into an SQL-92 compliant database, as well as sharing data with another user of Lotto Sorcerer. You can also use this to export data back into Lotto Sorcerer.

Please note that unregistered versions of Lotto Sorcerer are limited to 50 records for exporting.

How to Invoke

Use the menu item "Lottery Data > Export Lottery Data > Export as SQL File" .

Basic Procedure

Window Controls

"Select Lottery" dropdown

Choose the lottery you want to export.

"Tablename" text box

Enter the tablename that will be used in the SQL file (in the 'insert into…' clause).

"Append Semicolon" check box

If your database expects a semicolon after each SQL statement (most do), check this box.

"Draw Date" field name text box

If you are using the "Include Column Names" option, enter the field name for the date field.

"Draw Time" field name text box

If you are using the "Include Column Names" and the "Include DRAWTIME Field" options, enter the field name for the time field.

"Field Prefix" text box

Enter the field prefix to be used. Lotto Sorcerer will automatically append field numbers (from 1 to the number of fields after this character).

"Include Column Names" checkbox

If you wish to use the field names in the 'insert into…' clause, check this box.

"End-of-Line Terminator" dropdown

Different operating systems use different characters to mark the end of line. Choose the appropriate one.

Export button

Clicking this button starts the export process.

"Cancel" button

Use this to close the current window and return to the Main window.