|
Excel-to-MySQL
is a program to convert Microsoft Excel spreadsheets into
MySQL databases.
Depending on
your privileges on the target MySQL server you can export MS
Excel data into new database or overwrite the contents of an
existing MySQL database.
Excel-to-MySQL Features:
- All versions of MS Excel
are supported
- Works with all versions of
Unix and Windows MySQL servers
- Converts individual
worksheets
- Merges MS Excel data into
an existing MySQL database
- Converts Comma Separated
Values (CSV) files into MySQL tables
- Command line support
- VServer user's option (see
below)
- Exports data source into
MySQL dump file (see below)
- Easy-to-use wizard-style
interface
- Full install/uninstall
support
Excel-to-MySQL
System Requirements:
- Windows 2000/XP or Windows
NT 4 with Internet Explorer 5 or later or Windows 98/ME or
Windows 95 with Internet Explorer 5 or later
- At least 32 MB of
available memory
VServer
user's option
If you are using Virtual Server hosting you probably have no
sufficient privileges to create new databases on the target
MySQL server. For this case we recommend the following
approach:
- ask your
Virtual Server administrator to create blank database for
you
- run
Excel-to-MySQL and select this database as the conversion
target
- click
"Yes" when you will be asked if you'd like to overwrite
existing MySQL database
When you
complete these steps, the entire contents of the source MS
Excel spreadsheet will be imported into the specified MySQL
database.
MySQL dump file
Excel-to-MySQL allows users to perform deferred conversion and
get more control over the process. Following this way, the
program stores the contents of the data source into a local
dump file instead of moving it to MySQL server directly. The
resulting file contains MySQL statements to create all tables
and to fill them with the data. You will be able to import
this file into existing MySQL database via MySQL client as
follows:
mysql.exe --host=... --user=... --password=... -vvf {MySQL
database name} < {dump file name} |
