A small tool that can convert any .CSV document to a SQL query. #CSV converter #Convert CSV #CSV Data #CSV #Converter #Convert
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.
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 requirements
- MS SQL Server Database file
Cyber-D’s SQL Wizard 2.01
add to watchlist add to download basket send us an update REPORT- runs on:
- Windows All
- file size:
- 3.1 MB
- filename:
- sqlwizard.exe
- main category:
- Internet
- developer:
- visit homepage
4k Video Downloader
calibre
Context Menu Manager
IrfanView
Microsoft Teams
Windows Sandbox Launcher
7-Zip
Bitdefender Antivirus Free
Zoom Client
ShareX
- Bitdefender Antivirus Free
- Zoom Client
- ShareX
- 4k Video Downloader
- calibre
- Context Menu Manager
- IrfanView
- Microsoft Teams
- Windows Sandbox Launcher
- 7-Zip