Air Compressor Bot
|
|
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Simple! Excel spreadsheet to MySQL |
 |
Bidding Time: |
28/04/2008 23:35 - 05/05/2008 00:00 |
Budget: |
$30-250 |
Status: |
Pending |
|
|
|
Job Type: |
|
Description: |
I need a simple program that converts excel files into mysql tables. First row of the xls-spreadsheet consist of names of the columns, which need to be added to a new table in MySQL. Name of the table may be decided somehow(manually, name of the spreadsheet, filename etc). Excel file needs to be "uploaded" or chosen into the program, and after that program asks connection settings of the MySQL database. Basic MySQL commands this project needs, are as follows: Connection: mysql -u[username] -p[passwd] -h[db_address] [dbname] example: mysql -uroot -proot -h127.0.0.1 mydatabase Creating database and table happens like this(example): (new database) (1. mysql -uroot -proot) (2. create database db) (3. use db) 4. creating table: CREATE TABLE `NameOfTheTable` ( `id` int(10) unsigned NOT NULL auto_increment, `number1` int(10) unsigned NOT NULL, `number2` int(10) unsigned NOT NULL, `text1` text NOT NULL, `text2` varchar(20) NOT NULL default '', `date_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; Now, if you would rather like to make all data as varchar(255), it's okay. In short: -Upload/choose xls file -review the columns: which will be added, which not -connection settings -create new table/add to existing table* -insert data to MySQL(skip empty rows) -MySQL port is 3306 *Adding to an existing table this is simpler(after connection): insert into NameOfTheTable set number1=1234, number2=4321, name="lorem ipsum" etc. I don't care how you do this, php, java script, java client...whatever. However, I will need to use this program either with browser or a with a client application. Choose the best option. You have to code this yourself and all the rights belong to me. Money via escrow immediately after project is done. Next:  Online Dating Templates -
Simple Psd To Html/form -
Private project - tex/cover image -
Global classifieds website -
License Agreement -
This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
(None) |
Database System: |
MySQL |
|
| |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2007 ProjectsList.biz /0.479 |