Annulleret

Simple! Excel spreadsheet to MySQL

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.

Færdigheder: Dataindførsel, Excel, Java, Javascript, PHP

Se mere: via escrow, upload yourself, to p, spreadsheet script, simple file database, php script null, php and mysql connection, p.c. connection, mysql database application, me excel, make money with java, make money with excel, lorem ipsum do, java and excel, id to code, how to null php script, how to null a script, how to null a php script, how to create database program, excel to application, excel &, creating php table, care now, care connection, php insert excel create table mysql

Om arbejdsgiveren:
( 7 bedømmelser ) Helsinki, Finland

Projekt-ID: #255671

23 freelancers are bidding on average $125 for this job

skywalker65535

Please see pm

$150 USD på 1 dag
(29 bedømmelser)
6.4
Ajz

ready to do it for u. quick and easy.

$50 USD in 3 dage
(44 bedømmelser)
6.4
junaidart

Get work done fast. Please Checkout PMB

$100 USD in 3 dage
(97 bedømmelser)
6.1
fstudio

Dear sir, I am very interested in your project, Please see PMB for more details. Thanks. Best Regards.

$150 USD in 2 dage
(66 bedømmelser)
5.6
voituk

Easy to do. Already have a code that reads XLS files.

$100 USD på 1 dag
(26 bedømmelser)
5.5
fastwebsolutions

See pmb for more information Thank you.

$250 USD in 7 dage
(14 bedømmelser)
5.6
MKCline

I will be more than happy to assist you with this. Please check your PMB.

$125 USD på 1 dag
(16 bedømmelser)
4.2
lavelleinfosys

This can be done.

$150 USD in 12 dage
(2 bedømmelser)
4.1
frustum

Can complete quickly

$70 USD på 1 dag
(14 bedømmelser)
3.1
vnb400

kindly refer PMB, Thanks

$55 USD in 3 dage
(3 bedømmelser)
2.3
Kuppabai

I am interested in this project.

$200 USD in 7 dage
(0 bedømmelser)
0.0
uvsatech

We are happy to introduce ourselves as UV SaTech, an industry leader in IT Services, Engineering Services, Global Sourcing, Consulting Services, BPO Services, Software Development, Web Development and 3D Presentation.

$250 USD in 20 dage
(0 bedømmelser)
0.0
haeloong

hi, i did this kind of simple project before using swing or command at your convenient. please pm. tq.

$60 USD in 2 dage
(0 bedømmelser)
0.0
asilachev

Hi! I have exactly the same task while working on my previous project. So I'm able to customize code for your task really fast, since code have been well tested before.

$100 USD in 2 dage
(0 bedømmelser)
0.0
phpdeveloper08

hello,sir. plz check pm. thanks.

$150 USD på 1 dag
(0 bedømmelser)
0.0
csspune

Please view PMB.

$50 USD in 2 dage
(0 bedømmelser)
0.0
mohdasheer

i am intrested to same

$50 USD in 4 dage
(0 bedømmelser)
0.0
sebicherian

Our Company already developed a software for converting excel to mysql

$200 USD in 10 dage
(0 bedømmelser)
0.0
HcubeIndia

I already have build ready for this in java..let me know if it works for you.

$100 USD in 0 dage
(0 bedømmelser)
0.0
thedoubt

Hi, I'll foloow the folowing steps: There will be User Interface to Upload Excel file,name table to be created. Actually it will be a Form with input boxes. I'll use PHP5 and MySql. I'll upload sample application o Mere

$200 USD in 3 dage
(0 bedømmelser)
0.0