Macro Excel to upload into MySQL Table
Budget $30-250 AUD
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.
Awarded to:
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
33 freelancers are bidding on average $216 for this job
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
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
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
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
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
hello, i have more then 7 year experience in development and i easily can do this task done ready to start work now thanks..............
Hello Sir i have read it, and ready to start it now.....................................................................................................
we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship.
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
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
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
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
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
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...