Excel Macro to upload into MySQL Table


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: export data from excel to mysql using vba, vba mysql, excel vba sql query example, mysql for excel vba, excel vba insert into sql server, inserting data into mysql from excel using vba, excel vba connect to mysql, how to get data from sql server to excel using vba, excel table mysql, upload data excel mysql opencart, macro excel query csv, php insert excel create table mysql, pivot table macro excel 2010, upload website excel macro, solidworks macro excel design table

About the Employer:
( 41 reviews ) melbourne, Australia

Project ID: #14417215

15 freelancers are bidding on average $513 for this job


Hi, I am good at Excel and building useful scripts for my clients. I would like to know about the backup directory etc. I just checked the description you have provided regarding the project and would be a pleasu More

$250 AUD in 1 day
(657 Reviews)

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

$555 AUD in 10 days
(196 Reviews)

Hi, I (Myself a senior PHP Developer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the ve More

$721 AUD in 12 days
(27 Reviews)

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore More

$721 AUD in 12 days
(55 Reviews)
$526 AUD in 10 days
(39 Reviews)
$250 AUD in 5 days
(85 Reviews)
$400 AUD in 5 days
(36 Reviews)

Dear Hiring Manager, I read your job desciption and I am confident that I can exceed your expectations. I am a professional programmer on PHP+MySQL+WordPress. Here are few recent work for website development : More

$555 AUD in 10 days
(20 Reviews)

I would like to apply to it. I'm a web developer with 7 years experience in PHP, MySQL, CSS3, HTML5 and deep knowledge WordPress, WP plugins, development issues

$555 AUD in 10 days
(28 Reviews)

We have done big and complex projects with quality and most of our business comes with repeat hires because of that, so looking forward to build a long term working relationship with you. Let’s have a chat session!! More

$444 AUD in 10 days
(20 Reviews)

A proposal has not yet been provided

$666 AUD in 5 days
(12 Reviews)
$777 AUD in 10 days
(5 Reviews)

Dear Sir/Madam, I am a professional Excel VBA programming expert. I have 7 years of experience designing and developing Excel spreadsheets filled with formulas and VBA code. I have great experience in any kind of More

$500 AUD in 10 days
(9 Reviews)

Our vision is to help to bring your project into the market more faster and comfortable. We work with client big and small across of trends and are taken keep to prove themselves in this industry. Sectors and we util More

$500 AUD in 10 days
(0 Reviews)
$277 AUD in 8 days
(1 Review)