In Progress

Macro Excel to upload into MySQL Table

Hello

I have a excel file which is macro enabled with a hidden sheet. i require the following work

1. Create a macro which will upload the data from the hidden sheet into a mysql database

[url removed, login to view] mysql database already has a table which matches the structure of the hidden excel sheet

3. the data must insert and update

4. if there is an error uploading/connecting the excel macro must not error. It must show a error to the user stating the upload was not successful

5. if the upload was successful a message needs to pop up to display successful

6. When the upload is successful the macro must also output a csv file of the data uploaded into a backup directory

7. the macro must be able to be configured to allow to switch between different mysql server IP's, user and password.

On success of awarding the project i will send the excel macro file to the awarded winner.

Skills: Excel, MySQL, PHP, Software Architecture

See more: excel macro xml csv, excel macro compare csv, mysql upload excel ruby, excel macro graph csv, macro convert csv excel, excel macro compare table

About the Employer:
( 32 reviews ) melbourne, Australia

Project ID: #14417322

Awarded to:

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st More

$150 AUD in 2 days
(474 Reviews)
7.9

34 freelancers are bidding on average $217 for this job

A2Design

Hi, this looks like something we could help you with. Our team is Russian-Canadian. We specialise in: PHP & PHP frameworks, WordPress & Woocommerce, Opencart, Magento, API development, HTML5, CSS, JavaScript, Bootstra More

$350 AUD in 3 days
(93 Reviews)
8.4
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$237 AUD in 10 days
(363 Reviews)
8.1
cgullapalli

Hi, I am good at Excel,MySQL and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra

$60 AUD in 1 day
(494 Reviews)
7.5
malviyamanish

Dear Client , We gone through project description We are Really intrested to do work with you , We are Web & Software development company having more than 8 year experience in Software development we totally commit More

$155 AUD in 3 days
(165 Reviews)
7.2
Webxpert4u

Hello, I am ready to Create a macro. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel Macros. LET'S More

$150 AUD in 3 days
(130 Reviews)
7.0
letshappy

hello, i have more then 7 year experience in development and i easily can do this task done ready to start work now thanks..............

$233 AUD in 4 days
(114 Reviews)
6.8
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$120 AUD in 2 days
(179 Reviews)
6.9
aryan151

Hello Sir i have read it, and ready to start it now.....................................................................................................

$30 AUD in 3 days
(205 Reviews)
6.4
webteklab

Hi, Got the concept of uploading the Macro Excel to upload into MySQL Table. I will implement the same as described. Please send me the details. Initiate a chat session for more discussion about the project More

$150 AUD in 3 days
(87 Reviews)
5.9
tomkusvw

Hi! My name is Tomasz Kustra, and I am from Poland. I am interested in this project. What exactly Excel and Windows do you want to use? Working with external database with Excel can be trickuy becouse differe More

$300 AUD in 10 days
(60 Reviews)
5.6
axiomswb

we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship.

$50 AUD in 2 days
(61 Reviews)
5.8
codetastic

Hello, PLEASE NOTE: As I do not own a windows pc, this bid is contingent on using python or php to perform the requested functionality rather than a vba macro. If that is acceptable, I would be happy to assist! I a More

$250 AUD in 5 days
(27 Reviews)
5.3
mahmoudgamal008

I have a better idea and I did it before for very similar scenario. I can develop a windows service which will monitor and watch for any changes in the excel file, then it will take these changes and do whatever you wa More

$250 AUD in 5 days
(37 Reviews)
5.2
ForeignTree

What do you mean here? the macro must be able to be configured to allow to switch between different mysql server IP's, user and password You mean to say that you can change the MySQL server details to upload t More

$200 AUD in 3 days
(15 Reviews)
5.5
LuckyQ

Hello, ***** Your Search Ends Here ***** -------- First Accept my Attendance ---------- I would request you to visit my profile page (https://www.freelancer.com/u/Sam4Everything.html)and then check my rece More

$155 AUD in 3 days
(22 Reviews)
4.7
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec More

$30 AUD in 1 day
(28 Reviews)
4.4
BeautiCG

Hi,dear. I am a senior software developer. I have just checked your project report, I am able to perform this task with my developer team. I am looking forward to your proposal...

$155 AUD in 1 day
(13 Reviews)
4.1
Ahmed818

Hello, i am very interested in your project i am expert in VBA programming , i can write the macro to read data from hidden sheet then send it to mysql database i will let user enter many userlogins and IPs More

$50 AUD in 1 day
(16 Reviews)
3.8
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$100 AUD in 3 days
(11 Reviews)
3.7
harrisoneggers

Hello, I have been creating interfaces between Excel and SQL Databases (Of various types) for the past 2 years. Your project seems simple enough and very well thought-out, but I do have a few questions before we get More

$100 AUD in 5 days
(2 Reviews)
3.7