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.

Clarification on point 7.
7a. Within the maco code i want to be able to switch the IP address and login detail of the MYSQL server to another one (backup) if required. this point is to ensure i can easily configure the connection details.

Skills: Excel, MySQL, PHP, Software Architecture

See more: export data from excel to mysql using vba, vba code to import data from excel to sql server, vba database connection, sql macro excel, excel vba insert into sql server, sql table to excel sheet vba, update sql table from excel vba, vba oledb, excel macro xml csv, excel macro import csv create pivot table, excel macro create csv file, excel macro compare csv, macro import csv excel table, excel macro parse csv, read data table pdf file excel macro

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 [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view] More

$150 AUD in 2 days
(511 Reviews)
8.0

33 freelancers are bidding on average $216 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
(102 Reviews)
8.5
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
(375 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
(556 Reviews)
7.6
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
(141 Reviews)
7.1
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
(207 Reviews)
7.2
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
(176 Reviews)
7.4
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
(123 Reviews)
6.9
aryan151

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

$30 AUD in 3 days
(234 Reviews)
6.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
(63 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
(40 Reviews)
5.9
LuckyQ

Hello, ***** Your Search Ends Here ***** -------- First Accept my Attendance ---------- I would request you to visit my profile page ([url removed, login to view])and then check my rece More

$155 AUD in 3 days
(33 Reviews)
5.7
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
(62 Reviews)
5.7
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
(100 Reviews)
6.1
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
(23 Reviews)
5.5
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.3
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
(37 Reviews)
4.8
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
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
(18 Reviews)
4.6
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
(19 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
(20 Reviews)
4.1