You are here: Home > software > Web Authoring > HTML Editors >
 

xls2mysql 1.0

  • Ratings:
  • Version:
  • License: Commercial
  • System: Win95/Win98/WinMe/WindowsXP/Unix
  • Author: Pole Ouest
  • Date added: 2005-10-6 9:23:01
  • File size: 20KB
  • Limitations:
Description
. WHAT Does it do

uses first line of the excel file to create sql columnss
uses filename to create table
uses each following row (from 2 to N) to create inserts.
does not actually perform the sql : please copy and paste to your favorite sql admin interface.

2. WHAT DOESN'T IT DO (YET)

detect field types (numeric, text, longtext, unique)

3. Xls2Mysql requirements : you'll need php > 4.0.6

4. HOW TO USE xls2mysql :
After payment has been confirmed (ses below), you'll get unlimited access to the xsl2mysql download adress.
get the package 'xls2mysql.zip' and unzip it to a web folder that has PHP
run the xls2mysql.php page within your browser
Upload the files or test from the sample xls files from the file list tab
if you upload files, check that php has read/write rights on the xls folder.
Related softwares:

  1. EMS Data Import 2005 for MySQL 2
    EMS Data Import for MySQL is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to MySQL tables.
  2. EMS SQL Manager 2005 Lite for MySQL 3
    EMS SQL Manager Lite for MySQL is an excellent freeware graphical tool for MySQL Server administration.
  3. Backup Watcher for MySQL 1.9
    Program Backup Watcher for MySQL is intended for making database backups of the MySQL server.
  4. DBF to XLS (Excel) 1
    The DBF to XLS (Excel) program allows you to convert your dbf files to XLS (Microsoft Excel) format.
  5. odbc2xls 2.7
    O2X (odbc2xls) offers the user a simple, fast and effective method to extract ODBC Table Data from the local ODBC driver into an Excel XML based Sprea.
  6. Export Query to Excel for SQL Server 1.02
    Export Query to Excel for Microsoft SQL Server helps to save results of a query execution to Excel spreadsheet.
  7. MySQL to Text Files Import, Export & Convert Software 7
    Save MySQL tables to text or CSV files.
  8. Toad for MySQL 2.0
    Toad for MySQL empowers MySQL developers and administrators develop code more efficiently.
  9. MySQL MS SQL Server Import, Export & Convert Software 7
    This application will allow you to transfer tables to and from MySQL and MS SQL Server 2000 and 2005 databases.
  10. EMS Data Comparer 2005 for MySQL 1
    EMS Data Comparer for MySQL is a powerful and easy-to-use utility for data comparison and synchronization.
 
 
  Sub-Categories
 
 
 
Recommended
 
 
 
Most Popular