Project Detail

Grab Data from Excel file with multiple worksheet and import to mysql  

Grab Data from Excel file with multiple worksheet and import to mysql is project number 361523
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 12/24/2008 at 2:11 EST

Bid Count: 28

Average Bid:
$ 147

12/31/2008 at 2:11 EST

Project Creator: vjfromgt
Employer Rating: 9.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/109.8824/10 (17 reviews)

Bid On This Project
 

Description

I will need a table in which I will provide userid and password
this userid and passw will go to a website, log in and download excel files (web site will be provided later)

Every excel file has multiple tabs
the First 2 tab names are the same in every file
Will need to extract several defined cells and insert into a table
I must be able to add and remove what cell to import using a web gui
I must also be able to define which cell to import what to field

the rest of the worksheets can have random names but all starting with the word x
script must go through all all worsheet whose name start with x and extract defined fields from every one of the worksheet starting with x and put them into a second table

process must repeat for every login and every file downloaded
if there are more than 1 worksheet starting with x and having the same name , only use the very first one, ignore the others

There are existing software/script out there which can already import form excel onto mysql , you may use those

an example file has been uploaded, please look at the multiple worksheets



Additional files submitted:
Invoice-2810000002305-20081001.xls

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

200

5 days

12-24-2008 02:22 EST

Hello,Please refer your PMB.Thank you.

help

 

225

4 days

12-25-2008 11:44 EST

We can help in your project, please check PMB to see our related experience.

help

 

80

0 days

12-24-2008 05:24 EST

pretty easy work.

help

 

250

1 day

12-24-2008 21:00 EST

+++++++++ Please refer your pmb +++++++++++++

help

 

150

5 days

12-25-2008 04:21 EST

We can handle this. Take a look on our portfolio at http://www.a2design.biz/portfolio

help

 

130

0 days

12-24-2008 06:04 EST

hi there, I am an expert in excelvba and mysql/sql. This seems a very straight forward task and I can complete it easily for you. Merry christmas.... Kind regards Nash

help

 

80

2 days

12-25-2008 06:40 EST

Please, see pmb

help

 

30

0 days

12-24-2008 02:14 EST

Plz check PM

help

 

30

1 day

12-24-2008 06:19 EST

Dear sir, Please check the PM Sincerely Rajendra

help

 

110

3 days

12-25-2008 09:23 EST

This can certainly be done using Excel VBA. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.

help

 

150

4 days

12-27-2008 04:36 EST

Have experience of such tasks

help

 

150

3 days

12-31-2008 00:39 EST

I'm an expert in data processing, data mining. I finish and deliver the project in the fastest possible time. If you are interested we can discuss the details on PM.

help

 

249

7 days

12-24-2008 05:45 EST

**ISO Certified IT firm** Team of Certified Developers/ Designers, Development based on Industry Standards like W3C, Web 2.0 etc. ***It is a SERIOUS--BID considering your time/ budget and project description *** We will provide you detailed Proposed Solution, Mockup & Samples so you can make-up your mind. ***It’s WORTH to look at PM for our Proposed Solution & ***COST***. Regards

help

 

200

5 days

12-28-2008 17:43 EST

Please see PM for details. Thank you!

help

 

100

3 days

12-24-2008 13:53 EST

Please, check your PM box

help

 

250

6 days

12-25-2008 05:09 EST

We have gone through the information that you have provided and understand your requirements very well. We have excellent expertise in PHP5, MYSQL, DRUPAL, JOOMLA, HTML, CSS, AJAX, JAVA, J2ME, JSP, SEO, SEM, ASP.NET, VB.NET. We have worked on variety of web applications like Content Management Systems, Facebook Applications, Shopping carts, RSS Feeds, PDF generators, Banner Management, Modules Social Networking portals, Video portals, IMPORT/ EXPORT to excel, ERP's, etc. We have a very good hard working team in place who will be working on your project. Also we have good bench strength. We are looking for long term relationships and are open on price and payment terms. Please contact us right away to know more about our past work and team. We would be glad working with you.

help

 

110

2 days

12-24-2008 04:13 EST

(No Feedback Yet)

We can grab excel data and insert into MYSQL database. Please Contact us for further details.

help

 

190

60 days

12-24-2008 05:22 EST

(No Feedback Yet)

If you accept my bid and see the pmb

help

 

200

1 day

12-24-2008 05:23 EST

(No Feedback Yet)

Can do this job.

help

 

100

3 days

12-24-2008 05:51 EST

(No Feedback Yet)

pls consider my bid because i want to establish a long term relationship with you. We could still renegotiate the price down

help

 

200

2 days

12-24-2008 06:07 EST

(No Feedback Yet)

i can do the work !!!lets start ..

help

 

125

5 days

12-24-2008 06:17 EST

(No Feedback Yet)

With over 5 years experience in the field of Information Technology, I can offer you a wealth of experience in major IT services including customers and vendors engagements. I deliver quality work on time and on budget, ensuring that your projects remain on schedule. I am a motivated self-starter, but can also work comfortably in a team environment.

help

 

30

5 days

12-24-2008 06:25 EST

(No Feedback Yet)

Highly skilled management professional, having varied experience in data manipulation in excel. Please visit my profile for details

help

 

195

5 days

12-24-2008 10:30 EST

(No Feedback Yet)

I'm Excel/VBA expert.I will do done your project.

help

 

250

0 days

12-24-2008 10:57 EST

(No Feedback Yet)

i there , i can do the job, and more, just give me the job i you will see

help

 

195

6 days

12-25-2008 06:26 EST

(No Feedback Yet)

Hi, Please check PMB for details. Thanks, Veera

help

 

30

1 day

12-25-2008 07:13 EST

(No Feedback Yet)

I have several years experience in data entry, and I also have worked with Excel files.

help

 

101

0 days

12-30-2008 15:56 EST

(No Feedback Yet)

you can trust on my work.it will be great. I will work untill you get 200% satisfaction.

help


    Bid on this Project