Suoritettu

C # expert to create an import script from excel to SQL Server

I need a C # script to import two excel spreadsheets (Template 1 and Template 2 attached) into an Azure SQL Server. This script should do the same as the OPENROWSET command does. All rows and columns must be imported without any processing.

There will be two milestone payments. Half when the script is delivered and half at the end of the validation, if all the tests run successfully, including performance.

A simple form windows should be built as ”Form 1” file to run the script.

Attention points:

• The import should last less than 30 seconds on a standard internet connection (5MB), both for physical or temporary tables

• The first column of the tables must be an identity (int, 1,1)

• Destination tables must have always 12 columns. If the row of the worksheet does not have 12 columns, the remaining columns of the table must be null

• Some columns in the spreadsheet are displayed differently than their content, such as column “C376” of file “Template 1”, where the displayed value is "135: 06: 00" and the formula bar is "05/01/1900 15:06: 00 ". The value that should be imported into SQL Server is "135: 06: 00"

Taidot: C# -ohjelmointi, tiedonsyöttö, Excel, SQL

Näytä lisää: Need C++ Expert, i need a website for my company it has to very simple need 45 different pages homecontact about uscareer etc i need s, i need a website for my company it has to very simple need 4-5 different pages homecontact about uscareer ,etc i need s,, data entry, c# programming, sql, excel, azure, import data excel sql server devexpress, import excel sql server 2008, need simple ipad app built, import data excel sql server daily, import excel sql server compact, need simple pos windows, import excel sql server 2000 vb6, need simple ecommerce site built, import data excel sql server, import excel sql server, create table script generator sql server sql server, create table script generator sql server

Tietoa työnantajasta:
( 3 arvostelua ) São Paulo, Brazil

Projektin tunnus: #17044058

Myönnetty käyttäjälle:

achrafchiboub

Hi, I can do this job for only 99 BRL........................... Ping me for more details..........................................

R$114 BRL 3 päivässä
(7 Arvostelua)
3.2

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

liangjongai

Hi! I'm interesting your project very well. I am mastering c# and sql. And also I have many experience and good skill about web development. Let's go ahead with me

R$500 BRL 3 päivässä
(156 arvostelua)
6.8
jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Lisää

R$511 BRL 3 päivässä
(33 arvostelua)
5.2
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac Lisää

R$466 BRL 3 päivässä
(21 arvostelua)
5.1
Agiletechstudio

Hi, there i read your initial requirements and i have some question regarding to your import from sql [login to view URL] can we discuss it on chat ?

R$277 BRL 3 päivässä
(24 arvostelua)
4.9
imteyazkhan85

Hi There, I have understood your requirement, Will deliver you Script as per your requirement. And i am ready for 2 milestone concept. you run the script and then release it. I am an expert programmer having exper Lisää

R$333 BRL 3 päivässä
(23 arvostelua)
4.2
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Lisää

R$388 BRL 3 päivässä
(14 arvostelua)
3.4
R$444 BRL 5 päivässä
(1 arvostelu)
2.5
mozammalidbctg

Hi, I am experts in .Net, C#,Vb,Windows application,Asp.net Web Forms, MVC,WCF Service, Web Service, Web API,MSSQL Server 2014,2012,20082,2008,2005,2000,Crystal report ,Krypton Toolkit for Windows application Design Lisää

R$115 BRL 3 päivässä
(3 arvostelua)
2.5
R$466 BRL 1 päivässä
(1 arvostelu)
3.3
mantsoetoro

Hi, I see you are looking for c# expert, you can hire me to complete your requiremenrs. Please visit my profile to proof that I am worthy. Thank You

R$350 BRL 1 päivässä
(3 arvostelua)
2.1
sohaibmughal1232

Hello I checked your job description and ready to Start immediately. I have done many projects like this. I guarantee high work, quickly answer your message and responsibilities. I would like to do the job first w Lisää

R$400 BRL 3 päivässä
(2 arvostelua)
1.2
mijazamir

I can do this task i have 3+ years of experience in c# windows form

R$222 BRL 3 päivässä
(0 arvostelua)
0.0
ys1235741

Yousuf

R$466 BRL 3 päivässä
(0 arvostelua)
0.0
R$166 BRL 3 päivässä
(0 arvostelua)
0.0
greenforest0204

Hi there, I am a senior software developer who major in sql and c#. Please contact me if you are looking for a freelancer who is reliable and capable. Looking forward to your reply. Regards

R$466 BRL 3 päivässä
(0 arvostelua)
0.0
Softwcreative

i am interested in your project and i have read through. i have extensive commercial and ordinary coding knowledge of c#. i can code and import excel to your requirement.

R$716 BRL 3 päivässä
(0 arvostelua)
0.0
edwinalejandroc

I am a developer with skills in Basic language, C #. NET, JavaScript as well as technologies such as Html and Css, I'm passionate about what I do, that's why your project is my project and I'll do it with the highest q Lisää

R$333 BRL 3 päivässä
(0 arvostelua)
0.0
sjspunia1991

i have 6 years of development experience in c# and in my current company we frequently transfer data from excel to sql server and vice versa.

R$298 BRL 4 päivässä
(0 arvostelua)
0.0
inspiredwhiz

I am an engineer and confident of what I can do and deliver. I can work on Arduino, Python, Matlab, Java among others. I am asking for a chance to work with you on your project. Thanks

R$96 BRL 1 päivässä
(0 arvostelua)
0.0
Pathania123

I have done a lol of work on importing csv,excel file into sql server.I can deliver you a good optimaize script for that and you can make me the payment after completetion Thanks

R$466 BRL 3 päivässä
(0 arvostelua)
0.0