I need a SQL database running on mysql that I can populate tables from Excel. Each table will be 1 tab on an Excel file. When a tab is uploaded to the SQL database it is to replace all data within that SQL table. This needs to be password protected with an admin level user.
The second half of the project is I need to be able to add to Excel files a tab, or multiple tabs that will download 1 of several tabs from the SQL database. This also needs to be password protected but a different password to the one used for uploading.
The SQl database will be hosted on our server running MySQL
Hello, thank you for your interest.
I am familiar with Excel VBA and mysql. I can help you write a macro/script as your requirement that transfers data between mysql and excel.
It will be my great pleasure if you contact me.
Thank you!
$133 USD 2 päivässä
5,0 (9 arvostelua)
3,8
3,8
22 freelancerit tarjoavat keskimäärin $141 USD tätä projektia
We are a team of developers and have coded many PHP scripts to upload data to database from excel and also export data from database to excel. I am confident of delivering as required.
Relevant Skills and Experience
PHP, MySql, SQL, Excel
Proposed Milestones
$263 USD - I will define once I have studied the excel. I will revise / confirm bid accordingly.
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project
Proposed Milestones
$150 USD - payment after work completion
populate sql DB with excel and udated excel with SQL
Relevant Skills and Experience
Excel/VBA/SQL
Proposed Milestones
$200 USD - Completed tool
Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects for US clients
Relevant Skills and Experience
1) Programming/Scripting
2) Application/Web development
3) Web Scraping
Proposed Milestones
$100 USD - This task will be completed within schedule
Hi, I'm interested to work on this project. Contact me for quick and professional work.
Relevant Skills and Experience
Full stack web developer
Proposed Milestones
$200 USD - Payment
hello,
i'd be glad to implement this Excel / SQL project for you. Looking forward to chat with you soon for more details.
Best regards,
Relevant Skills and Experience
Excel , MySQL,
Proposed Milestones
$155 USD - upon customer satisfaction
Hello sir, I am a computer engineer working with software development task.
Relevant Skills and Experience
I've read task description. I want to develop a software for this which can automate this task. I've worked with excel and mysql simultaneously in Java and I can help you achieve this. Do contact me..
Proposed Milestones
$100 USD - Project Milestone
Hi
I have experience in dealing with database related project. I work as a software developer and is a day to day task for me dealing with mysql queries. I can see you are also from uk same as me which will help with communication. Please drop me a message and i can talk you through how i will tackle this if i were to do this project.
Kind Regards
Jomin
I am a EXCEL EXPERT with Ms-Excel Related work Including Macros with 10 years of Exprience.
Relevant Skills and Experience
I have already completed About 2000+ On Various Freelance Websites
Proposed Milestones
$83 USD - Articles.
VBA macros should be able to do this very fine. I have in my jobs worked on similar tasks of getting data from Sql tables and writing it back in to Database.
Relevant Skills and Experience
I have professional level expertise in Excel, VBA and sql queries. While simple select/insert statement can read/load data back in tables optimization of queries is key in such cases
Proposed Milestones
$10 USD - Design tables that will store database from Excel
$10 USD - Create database and tables
$40 USD - Design and Create VBA macros with insert query to load data into tables
$40 USD - Design and Create VBA macros with dynamic select query to load data from tables into excel tabs
$11 USD - Protect excel tabs with password
Additional Services Offered
$1 USD - Option to select tables whose contents you want to pull in excel
Can we have separate empty Database on your sql server and i need access to only this database
