Product Home
Overview
Buy it!
Download it!
See it!
Support
FAQs
Business Analysis of Web...
Contact
Press Resources
PrivacySo you Want to Convert Excel to SQL?
Turn your Worksheets into Real SQL Database Tables
SQL Converter 2 for Excel is an easy-to-use tool that quickly converts your worksheets to real SQL database tables.
With SQL Converter for Excel, you can model your data as a familiar spreadsheet. Once you have the fields and data the way you need them, SQL Converter will help you build a real SQL database table that can then be easily loaded into your MySQL database server.
You don't 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, versions 3 - 5, database server.
Download the Trial Edition and have fun. You will have plenty of time to use the software before buying it. Once you start to enjoy the product, you will be able set your copy free by transforming it into the full edition without any further downloads.
|
|
|
Some Features of SQL Converter 2 for Excel
- Design and Export SQL right from your spreadsheet
- Save time while copying your data to the real database server
- Convert any tabular data file, that Excel can read, to MySQL
- The table wizard will help you pick field names and data types
- Supports long field names, including spaces
- Convert all Date and Time fields to the proper SQL date format
- Automatically remove extra white space from cell data
- Easily create new tables
- Easily append data to existing tables
- Convert as much data as the spreadsheet supports. That is columns A - IV and rows 1 - 65,536
Supported File Formats
You can convert any file format that Microsoft Excel can read to MySQL. For example, with Excel 2002, you can:
- Convert all Microsoft Excel files to MySQL
- Convert XML files to MySQL
- Convert Text Files to MySQL
- Convert Access Databases to MySQL
- Convert Lotus 1-2-3 files to MySQL
- Convert Quattro Pro files to MySQL
- Convert Microsoft Works files to MySQL
- Convert dBase files to MySQL
- Convert Data Interchange Format files to MySQL
So yes, SQL Converter really can convert any file that Microsoft Excel can load into MySQL tables! As you upgrade your copy of Excel or add additional file filters, you can convert those files too.
System Requirements:
- Microsoft Excel® 2000, or newer, for Windows®
- MySQL Database Server
- Tested with Excel 2000, 2002 (XP), and 2003
- Tested with MySQL 3.x, 4.x, and 5.x
|
|
|
Excel Add-In for Windows
- Version: 2.1
- Works With: Windows 7, Vista, XP, and 2000
- Language: US-EN
- File Size: 768 KB
- Price: $99
- 60 day money back guarantee
Testimonials
"I run a voluntary website and use the converter to interface between a
course list maintained by a colleague in Excel and the searchable
database on the website. SQL Converter was the missing link when the
original project was put
together and was really simple to set up and use."
Andrew Clark - Nextnorth Ltd, Cambridge, UK
"I work on several websites that rely on updates from Excel sheets supplied
by clients - your converter makes it very easy!"
Lyn I., Ontario, Canada
"I love the program. It just saved me about 4hrs of work."
Troy B., Kansas, USA
For Your Office
Do you need access to multiple copies of SQL Converter for Excel for your office? Do your people waste time and money struggling to get data into various MySQL databases because they only have access to clunky import tools.
Start saving your money today with a multiple-seat license for SQL Converter for Excel.
Get the FAQs
Will it work with Excel 2007?
SQL Converter 2 for Excel does work in Microsoft Office 2007. The SQL menu appears in the "Add-Ins" Quick Access Toolbar (QAT).
Does it use Adware or Spyware?
No. SQL Converter for Excel is pure try before you buy, limited evaluation software. It has no "phone home" activation and does not send data back to us.
Which Target Database Servers are Supported?
MySQL 3, 4, and 5 are supported target servers.
The output may or may not be compatible with other servers, including PostgreSQL, Microsoft SQL Server, and Oracle. However, these servers have not been tested.
Microsoft Excel Software
SQL Converter for Excel requires Microsoft Excel for Windows, which can be easily purchased from Amazon.