Cyber-D’s SQL Wizard

The Cyber-D’s SQL Wizard application was developed to be a small tool that can convert any .CSV document to a SQL query. This is typically useful if you receive an Excel document with data that you need to insert into MySQL.

Here is how it works:

1. Export the Excel document as a CSV file (where “;” is used as a separator).
2. Open that file using notepad and copy everything using CTRL+C
3. Run SQL Wizard and paste everything in the “CSV Data to insert” field.
4. 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 ;
5. 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.
6. Click on “Parse” to generate the SQL Queries. Double check if the query looks good and make modifications as needed. If the query string is too long, then simply copy and paste the generated queries into notepad to see the entire query for inspection.
7. If you are satisfied with the query then simply paste the queries into SQL or save it as a .sql file and load it in MySQL.
This tool can also be used to create any other type of queries if you modify the SQL Insert Query string to your needs.System requirementsMS SQL Server Database file