Kapalı

Import and Update Azure SQL from Excel/CSV

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

Beceriler: .NET, Azure, C# Programlama, Microsoft SQL Server, SQL

Daha fazlasını gör: import data from excel to sql server using query, import csv to azure sql database, sql server import and export wizard, import csv into sql azure, import excel into sql server 2012, how to import data from excel to sql server, import data into azure sql database, import excel data into azure database, I am looking for a re-design, I already have a specific theme employed on my website, however, the colors are all wrong - and I , m i x p a n e l com, azure sql import xml, update azure sql excel vba, import excel csv sql vb6, opencart update products price csv import, sql csv import vb6, prestashop csv import update, magento sql csv import, update sql database excel spreadsheet, sql csv import, sql csv update

İşveren Hakkında:
( 0 değerlendirme ) Sydney, Australia

Proje NO: #16563048

Bu iş için 33 freelancer ortalamada $181 teklif veriyor

ambar

Azure SQL Database supports import and export of .bacpac/ .dacpac files; So my approach is to use bcp command-line utility to import data from a CSV file into Azure SQL database. So regarding completion of the task Daha Fazla

in %bids___i_period_sub_35% gün içinde263%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(118 Değerlendirme)
8.3
the13thwarrior

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 impo Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(286 Değerlendirme)
7.9
rinsadsl

.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

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(89 Değerlendirme)
6.6
sergioeliot3

Hi there, Thanks for using our website freelancer com. I have reviewed the project description as well the attached Excel file and I am enthuasiastic about this project because I am 100% confident that I can do i Daha Fazla

in %bids___i_period_sub_35% gün içinde190%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(70 Değerlendirme)
6.6
hardikshah83

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, Mic Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)
5.4
sheikDev

Hello, I have been good to developed this job. im over 10 years experienced in .net. Thanks, Sheik

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(59 Değerlendirme)
5.7
Bl1tz1t

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

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
5.2
DavidLindon

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

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)
5.0
lukaszoz

Hello, I'm a developer with over 5 years of experience and work as a regular .Net developer on daily basics. I work with technology like : 1) Access and whole office stack (Excel, Word, Outlook) in terms of V Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.9
whizzaard

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)
4.5
in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)
4.5
BestPartner4You

Hi Sir, I am a super Excel/CSV and SQL developer and have 7 years of enough experience in this kinds of projects, so I can help you. I checked your all requirements and understood what you want. I will provide you be Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
4.2
zu02

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
4.7
ikramshah65

I have 6 years of web development experience in azure, C# , asp.net MVC framework, jquery, JavaScript, Ajax , SQL server, mongodb Here are the links of websites i have worked on of course there are many others h Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
4.1
SergioAlfaroV

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 wareh Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
4.4
mpapaleo

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
4.2
khanicha

It would be a simple [login to view URL] which can be managed from OleSQL library. So, you load the CSV by using SQL Statement. And using the Recordset object you can filter them as well.

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
4.0
in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.3
solhere

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
3.1
naeem76

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 question Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
3.1