Find Jobs
Hire Freelancers

Import and Update Azure SQL from Excel/CSV

$30-250 USD

Avslutat
Publicerad ungefär sex år sedan

$30-250 USD

Betalning vid leverans
I have an excel spreadsheet which is made up of 2 data types -Company -Company Categories The company categories are shared across companies. e.g. Row 1 - Company A, ImportId1 Row 2 - Cat 1, ImportId1 Row 3 - Cat 2, ImportId1 Row 4 - Company B, ImportId2 Row 5 - Cat 2, ImportId2 I want some code which can be run in a console or Azure function to update the SQL Azure tables with new customers and categories, linking up the company to categories. New Customers should be added to a Customers Table New Categories should be added to a Categories Table Updates to Customers should be updated Updates to Customers Categories should be updated Missing Customers/Categories are subsequent runs should be marked with a deletion flag This would be run periodically. There is already a table structure but this can be modified. -Customer -CustomerCategory -Category Please add your relevant skills and how you would approach this in the proposal or it will be ignored. Thanks
Project ID: 16563048

Om projektet

31 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
31 frilansar lägger i genomsnitt anbud på $179 USD för detta uppdrag
Använd avatar
Hello Sir, As per my understanding you want a console app or a Azure function to import Excel data and update database periodically. Please guide us if we are wrong, We have past experience with such excel import and database update as well as Azure platform, Hence I am please to offer my services for same. I am available right now to talk it further and get started. Thanks, Vipul
$277 USD Om 3 dagar
5,0 (294 omdömen)
7,9
7,9
Använd avatar
.Hello Good Day I have worked witg Azure database. I can import the data in Excel or CSV file to the company and category tables on your Azure storage. Looking forward tow orking with you. Rinsad
$200 USD Om 3 dagar
4,9 (103 omdömen)
7,0
7,0
Använd avatar
Hello! I'm an experienced .Net software developer (8+ years). I believe that I can help you with this data importing since I already have previous experience. Best regards
$166 USD Om 2 dagar
5,0 (41 omdömen)
6,8
6,8
Använd avatar
When you say console is that something you can run locally which would connect to azure as this would be the cheapest option to develop
$133 USD Om 5 dagar
4,9 (38 omdömen)
6,1
6,1
Använd avatar
Hello, I have been good to developed this job. im over 10 years experienced in .net. Thanks, Sheik
$100 USD Om 4 dagar
4,9 (78 omdömen)
5,9
5,9
Använd avatar
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. I propose to use a console app which will scan a particular folder in the system for the master sheet. If it founds one, it will connect Azure DB and perform tasks and once tasks are completed, move the file to a sub folder "Completed". More can be discussed and factored as needed. Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success.
$200 USD Om 3 dagar
5,0 (41 omdömen)
5,8
5,8
Använd avatar
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, and overall Business Intelligence related projects and tasks. I am a near-native English speaker, currently available, and results oriented - I am a freelancer, which requires little to none supervision to deliver. My strongest skill is SQL Server, and also have Azure as one of my top skills. I have done file import from flatfiles and Excel files to Azure before. I can help you with your request. My approach would be the following: - Create a Blob in Azure and upload the Excel file - Program a refresh (using PowerShell) to upload the file periodically (nightly?) to the Azure Blob - Make a Stored Procedure that reads the Excel/CSV file from the Azure Blob. Here we can use BULK INSERT or OPENROWSET methods and inserts/updates the data in its respective tables. - Schedule the execution of the Procedure. About the schedule; the file upload(refresh), the read from table and the insert/update can be programmed in Azure in one only schedule, with the needed periodicity.
$250 USD Om 3 dagar
4,9 (21 omdömen)
5,5
5,5
Använd avatar
Hi, I am an expert in Excel and have also worked in DB programming for more than 7 years. I have connected excel with remote DB to insert and update records. I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been working with Microsoft as customer delivering projects in MS technologies. Will be able to leverage this experience to deliver this project successfully. Thanks Regards Vaidy
$155 USD Om 3 dagar
4,9 (14 omdömen)
5,4
5,4
Använd avatar
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel macro enabled project - using SQL/ADO, very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$250 USD Om 3 dagar
4,6 (12 omdömen)
4,9
4,9
Använd avatar
A proposal has not yet been provided
$111 USD Om 3 dagar
4,9 (38 omdömen)
4,5
4,5
Använd avatar
I can create a windows application to import the excel into the Azure tables. If you need to run it periodically, it can be a windows service. I'm available right now to start the project. If you want I can create this as Azure function too (one drive -> SQL), but in this case my offer is 250.00 $. I went through your file but I cannot find the company categories. Please contact me on Freelancer.com chat to give me more information. I'm a senior developer and system architect. I've 20 years of experience on software developing on complex architectures.
$150 USD Om 3 dagar
4,8 (10 omdömen)
4,1
4,1
Använd avatar
Yes, I can do this project, as i have done many project related to excel file import and export using # technology. we can discuss more about this project thanks
$150 USD Om 5 dagar
5,0 (9 omdömen)
3,1
3,1
Använd avatar
function app with a timer code and uploading excel file on the blob is suffice to resolve the requirement. Please contact us in case of more clarification.
$222 USD Om 10 dagar
5,0 (7 omdömen)
3,3
3,3
Använd avatar
Hi I am very experienced with C# and SQL databases, and have done many projects regarding updating of SQL databases, so I can do your job easily and as required, thanks! PM me for more details if you have any questions/
$155 USD Om 4 dagar
4,7 (4 omdömen)
3,1
3,1
Använd avatar
A proposal has not yet been provided
$155 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I have got skill set to do the job. Experience of working and programming to transform csv excel documents to other data format. Proficient using c# windows app & Web app. Webapi wpf.
$277 USD Om 2 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Working as oracle plsql developer in a IT company for more than 3 years. I handle CRM (Customer Relationship Management) application for our USA Client. For your Project i can think of to create front end with .net framework and C# programming language and back end we will create plsql program to store/update/delete operation on a table. I think i will be the best candidate for this one.
$144 USD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
A proposal has not yet been provided
$155 USD Om 5 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I will able to deliver the work on time. Relevant Skills and Experience I have around 11 years of experience in Oracle Database in Application Support projects
$155 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi, I am a software engineer with great experience of c#, asp.net, SQL and Azure stack. I have worked with these technologies for 4 years. My approach to your problem will be like this. I will design a secure web interface or windows application to upload the excel file. The file will be uploaded to Azure blob storage. When the file is uploaded I will write some metadata to an Azure queue. Then I will use an azure Web-job, that will keep an eye on the queue. Then the Web-job can process the file as soon as the file is uploaded. Through the Web-job, I can then insert/Update the SQL database. Then the uploaded file can be deleted if you need. I need further details about this. Need a sample excel file and need clarification about the missing customer/category flagging scenario. Looking forward to discussing this further with you. Thank you.
$155 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AUSTRALIA
Sydney, Australia
5,0
1
Verifierad betalningsmetod
Medlem sedan dec. 8, 2007

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.