Dibatalkan

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.

Kemahiran: Pemasukan Data, Excel, Java, Javascript, PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 7 ulasan ) Helsinki, Finland

ID Projek: #255671

23 pekerja bebas membida secara purata $125 untuk pekerjaan ini

skywalker65535

Please see pm

$150 USD dalam sehari
(29 Ulasan)
6.4
Ajz

ready to do it for u. quick and easy.

$50 USD dalam 3 hari
(44 Ulasan)
6.4
junaidart

Get work done fast. Please Checkout PMB

$100 USD dalam 3 hari
(97 Ulasan)
6.1
fstudio

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

$150 USD dalam 2 hari
(66 Ulasan)
5.6
voituk

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

$100 USD dalam sehari
(26 Ulasan)
5.5
fastwebsolutions

See pmb for more information Thank you.

$250 USD dalam 7 hari
(14 Ulasan)
5.6
MKCline

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

$125 USD dalam sehari
(16 Ulasan)
4.2
lavelleinfosys

This can be done.

$150 USD dalam 12 hari
(2 Ulasan)
4.1
frustum

Can complete quickly

$70 USD dalam sehari
(14 Ulasan)
3.1
vnb400

kindly refer PMB, Thanks

$55 USD dalam 3 hari
(3 Ulasan)
2.3
Kuppabai

I am interested in this project.

$200 USD dalam 7 hari
(0 Ulasan)
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 dalam 20 hari
(0 Ulasan)
0.0
haeloong

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

$60 USD dalam 2 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0
phpdeveloper08

hello,sir. plz check pm. thanks.

$150 USD dalam sehari
(0 Ulasan)
0.0
csspune

Please view PMB.

$50 USD dalam 2 hari
(0 Ulasan)
0.0
mohdasheer

i am intrested to same

$50 USD dalam 4 hari
(0 Ulasan)
0.0
sebicherian

Our Company already developed a software for converting excel to mysql

$200 USD dalam 10 hari
(0 Ulasan)
0.0
HcubeIndia

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

$100 USD dalam 0 hari
(0 Ulasan)
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 Lagi

$200 USD dalam 3 hari
(0 Ulasan)
0.0