Product Home
Overview
Buy it!
Download it!
See it!
Support
FAQs
Business Analysis of Web...
Contact
Press Resources
PrivacyRelated Books
Screenshots & Video Tour
Video Demo
We still need to make videos of the new version. You can still see demo from the previous version. It's called From Excel to MySQL in Minutes (Windows Media Format). The interface is a little different now, but the basics are the same. Also, please enjoy the up-to-date screenshots and download the free trial edition.
Developer Tool
Please note that SQL Converter for Excel is a valuable developer tool that every web designer should have. You may wish to also consider investing in some good books on MySQL, including Learning MySQL by Saied Tahaghoghi and High Performance MySQL by Baron Schwartz.
Screenshots
SQL Converter for Excel works with Microsoft Excel 2000, 2002 (XP), 2003, and 2007. The following images show the program working in different versions of Excel. Click the image to see it full-size.
Starting SQL Converter for Excel
Start SQL Converter for Excel just like any other program in Windows. Since it is an Excel Add-In, Microsoft Excel will launch with SQL Converter enabled. |
Look for the SQL Menu
SQL Converter adds a SQL menu to your copy of Microsoft Excel 2000, 2002, or 2003. |
Designing a SQL Table in Excel 2000
Design your database table directly in Excel. Add, Edit, and Order your fields however you like. Choose Auto Design (red car icon) to get some some sensible defaults based on the data in the active worksheet. |
In Excel 2007 in Windows XP
|
|
|
|
Automatic Field Designer
The Automatic Field Designer will identify the header row and help you pick fields based on those already in the worksheet. It will help pick some data types, but don't worry because can easily edit them later.
Table Builder Tabs
The Table Builder has three tabs.
- Table Design and Mappings
- SQL Generation Options
- Export Range
The SQL Generation Options tab lets you change various options for how the MySQL code will be generated. Once you have selected the options you like, move on to the Export Range tab.
The Export Range tab lets you change which data is included in the generated MySQL dump file. Once you have review this and the other tabs, you can choose Export SQL to save the SQL for the current worksheet to disk. You will then be able to upload the resulting file to your database server.
|
|
|
Exporting the SQL
After running the SQL dump, you can review the export statistics and choose to either open the .SQL file or open its parent folder in Windows Explorer.
The resulting .SQL files are plain-text that can even be viewed with Notepad.
|
|
|
