SQL Converter for Excel

From Rietta Solutions:

Are you a web designer or programmer? Do you waste time with tedious data entry for your databases? SQL Converter 2 for Excel makes databases easy. Start with your familiar Excel spreadsheet and it will generate a MySQL database. Given any file that Excel can read, SQL Converter for Excel will identify the header row and let you select the best data-type for each column. For most files, you can have a MySQL database within three minutes. SQL Converter for Excel is an Add-In for Microsoft Excel for Windows. With it, you can convert any file that Excel can read to a real MySQL database. You can start with any file that Excel understands, including spreadsheets, Comma Separated Values (CSV), XML, and Data Interchange Format (DIF) files. Given data in Excel, SQL Converter can produce a MySQL database dump file.

• Stop wasting time reformatting data since SQL Converter figures out how each field needs to be formatted to be loaded by the server
• Layout your MySQL database through a familiar spreadsheet
• Your customers can enter their own data
• Avoid the hassle of CSV data-type mismatches

You do not have to be an SQL expert to get started with SQL Converter for Excel. Once installed, it will add a new SQL menu to your copy of Excel. From this menu you will be able to export one or more worksheets to a SQL dump file suitable for your MySQL database server.