- Export the Excel document as a CSV file (where “;” is used as a separator).
- Run SQL Wizard and browse for the csv or txt file.
- Give the columns in the CSV a unique identifier in the “CSV Column identifiers” field. You can use any name you like, as long as it’s between the [square brackets] and seperated by a semicolon. These variable names represent the columns of the CSV document in the same order.
- Modify the “SQL Insert Query” field to match your table name and table field names. Use the CSV Column identifiers you entered as values.
- Click on “Parse” to generate the SQL Queries.
- Click on “Save as SQL” to save the SQL query on your desktop.
- Open the SQL file for inspection and load into SQL database when satisfied.
A great alternative for my SQL Wizard is Exportizer. It has a lot more functions, processes data faster and supports more database formats.
However, if you have the money and if you want to make your life working with remote databases A LOT easier, then please for the sake of sanity take a look at NaviCat http://www.navicat.com/