In Progress

SQL and Excel Project

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

Skills: Excel, MySQL

See more: ssis excel destination sql command, ssis package to export data to excel and send email, ssis package export data from database to excel, ssis create excel file if not exists, excel destination in ssis, create excel file dynamically in ssis package, ssis excel destination create new file, export data from sql server to excel using ssis, convertire file sql excel, active directory excel file automate add user, aspx sql server project, vbscript update sql excel, add user excel, joomla sql excel converter, sql server project 2005

About the Employer:
( 29 reviews ) Crowborough, United Kingdom

Project ID: #14845057

Awarded to:

kepler452tech

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 con More

$133 USD in 2 days
(8 Reviews)
3.8

24 freelancers are bidding on average $138 for this job

hits

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 P More

$263 USD in 3 days
(734 Reviews)
8.7
schoudhary1553

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 ex More

$150 USD in 2 days
(192 Reviews)
7.1
dpune

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 More

$200 USD in 10 days
(134 Reviews)
6.3
axiomswb

We have expertise in excel oracl,dba, VBA, web scraping, data processing,data entry. Client satisfaction is our main motto for long term relationship.

$100 USD in 2 days
(55 Reviews)
5.8
libxml1

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

$200 USD in 2 days
(16 Reviews)
5.3
$53 USD in 3 days
(86 Reviews)
5.1
$133 USD in 10 days
(19 Reviews)
4.8
narsim3128

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 a More

$100 USD in 3 days
(30 Reviews)
4.7
lkhelladi

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 More

$133 USD in 3 days
(8 Reviews)
4.6
super2lao

Familiar interface and simple algorithm encourage your work. Languages: Objective C , Swift , PHP, Java, SQL, HTML, CSS, JavaScript, C, C++, C#,Python Web Frameworks: Laravel , Wordpress , CodeIgniter, Zoomla Dat More

$147 USD in 1 day
(6 Reviews)
4.4
$150 USD in 3 days
(7 Reviews)
3.9
$155 USD in 3 days
(5 Reviews)
3.9
smilemittal181

Hello, I have a 5+ working experience in WordPress Theme development and have developed number of Responsive WordPress Themes in my career from scratch from PSD to WORDPRESS or Creating mockup of the website like redes More

$155 USD in 3 days
(7 Reviews)
4.0
drudev

Hello. I am a web developer with 15+-year experience . I work remotely on DigitalRay company - [url removed, login to view] - LA (USA). Technical knowledges: [url removed, login to view] JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symp More

$111 USD in 3 days
(4 Reviews)
3.4
$155 USD in 3 days
(6 Reviews)
3.1
techcristaglobal

Have good experience in MYSQL. Relevant Skills and Experience MySQL Proposed Milestones $300 USD - intro

$300 USD in 3 days
(5 Reviews)
3.2
b0b90

A proposal has not yet been provided

$71 USD in 2 days
(1 Review)
2.4
rajenranpara

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 wi More

$100 USD in 5 days
(3 Reviews)
1.8
LiZhengXin

Hi, sir. I know about MySQL and Excel very well. IMPORTANT : I have full time for you. I can do this. Relevant Skills and Experience C/C++, Database, C# Proposed Milestones $150 USD - milestones

$150 USD in 3 days
(1 Review)
1.4
mohds2

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 US More

$83 USD in 3 days
(3 Reviews)
3.0