En cours

convert data from spreadsheet to MySQL database

The data is stored in Excel spreadsheet, I want a backend webpage which I can select the excel spreadsheet file from my local computer and import to the mysql on webserver, the requirments are:

1. the data from spreadsheet need to be displayed on the page with a checkbox before insert into mysql, once I tiick all the records I want, then I click a button, the script should only insert the records I selected.

2. some colmuns in spreadsheet needs to be combined in one column in mysql, eg. address line1,address line2, zipcode need to be put together into one column "address" in mysql separate by comma.

3. after all the selected records inserted into mysql, a new spreadsheet file with only I selected records need to be saved in another foler on my computer.

Compétences : Saisie de Données, Traitement de Données, Administration de Bases de données, Excel, PHP

Voir plus : spreadsheet script, processing the data, spreadsheet 2, together mysql, mysql database import, php import excel file mysql, excel file mysql, webpage spreadsheet database, mysql inserted, selected records, import database excel mysql, spreadsheet convert webpage, mysql spreadsheet, spreadsheet insert, php spreadsheet, mysql excel import data, mysql import select database, import data mysql excel, import mysql excel excel, mysql combined, mysql data import, convert excel file database file, php import excel file database, insert convert, import excel data php

Concernant l'employeur :
( 2 commentaires ) Alex, Australia

N° du projet : #2341573

Décerné à :

SuperMouse

Hi, I have done that before, I can handle it for you in several hours, please see message for more details

30 $ USD en 1 jour
(8 Commentaires)
3.4

13 freelance ont fait une offre moyenne de 142 $ pour ce travail

k1ng440

Full time freelance web developer with 7 years of commercial experience.

250 $ USD en 3 jours
(87 Commentaires)
6.4
keeperprancis

Ready to build your spreadsheet tools.

200 $ USD en 5 jours
(46 Commentaires)
5.7
adibr70

I have experience working with PHP, JavaScript, AJAX, MySQL and integration into a site. Check your Private Message to see some examples of sites that I made using PHP. Adrian

249 $ USD en 5 jours
(31 Commentaires)
5.6
experter

Let expert do this for you.

250 $ USD en 8 jours
(17 Commentaires)
4.8
WSolutionsinc

Hi Alex, i'm ready to start please see private message there is my skype id. Thank you.

70 $ USD en 2 jours
(24 Commentaires)
4.5
tehnicsmart

Hello , i`m ready

100 $ USD en 2 jours
(12 Commentaires)
3.7
Nzay

Good Day Sir, Please take a moment to check PM for my project proposal. Thank you

200 $ USD en 6 jours
(5 Commentaires)
3.4
MatKauton

PM for details

35 $ USD en 2 jours
(6 Commentaires)
2.9
swiftcult22

hello sir, lets begin :)

100 $ USD en 2 jours
(5 Commentaires)
2.8
jrthegreat1991

Good day! Please check PMS. Thanks.

80 $ USD en 5 jours
(6 Commentaires)
2.1
gue23TZT0yPL

Please check the PMB

30 $ USD en 1 jour
(0 Commentaires)
0.0
O0xZqI65J

Custom software development - <b><i>Removed by Admin</i></b>

250 $ USD en 1 jour
(0 Commentaires)
0.0