Cyber-D’s SQL Wizard 1.06

Cyber-D's SQL wizard makes it easy to generate SQL queries from CSV data. This tool is ideal for people who need to insert large amounts of data into an SQL database. If you always receive Excel documents and need to insert the data into an SQL database, then this tool is ideal. Simply save the Excel document as a Comma Sererated Value, import the file, change the variables (see video tutorial on product's website), click parse and save as SQL file. Now you can import the file in your SQL database.
Here is how it works:

1. Export the Excel document as a CSV file (where “;” is used as a separator).
2. Run SQL Wizard and browse for the csv or txt file.
3. Give the columns in the CSV a unique identifier in the “SQL string variables in order of CSV data variables” field. You can use any name you like, as long as it’s between the [square brackets] and seperated by a semicolon.
4. Modify the “SQL Insert Query” field to match your table name and table column names. Use the names you gave to the SQL columns in the query template.
5. Click on “Parse” to generate the SQL Queries.
6. Click on “Save as SQL on Desktop.”
7. Open the SQL file for inspection and load into SQL database when satisfied.

This tool can also be used to create any other type of queries if you modify the SQL Insert Query string to your needs.

PAD XML file