Find Jobs
Hire Freelancers

Convert XLS files and import into Azure SQL

$30-250 AUD

Завершено
Опублікований almost 6 years ago

$30-250 AUD

Оплачується при отриманні
We have been supplied XLS files to import user data (across 4-5 database tables) which requires: - Creating a user profile - Forcing certain data fields - Creating a repeated record that foreign keys back to the profile. It's in the sports industry, so any knowledge of Sports (specifically Hockey) will help you understand the terminology. Further details including the data file will be supplied to the successful applicant. We would expect that the end result (either SQL statement or C# .NET script) could be repeated in the future with similarly formatted files.
ID проекту: 17078094

Про проект

33 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Hi, I am interested to do this work. Please more provide more details. I am an experienced web developer. I worked in below technologies - ASP.NET MVC & ASP.NET ENTITY FRAMEWORK PHP - CRYSTALS REPORTS - C# , C++ , C - JQUERY , AJAX , HTML , CS , JAVASCRIPT - SQL SERVER , MY SQL - WEB DESIGNING - APP SCRIPTS , EXCEL VBA , MACROS Type of work that i have done. - Web application creation using - ASP.NET MVC - Entity Framework - JQuery, AJAX , JavaScript, HTML,Css - Report generation using Crystals reports and report builder - Importing CSV TO DB and Exporting of data to CSV file - Importing Excel TO DB and Exporting of data to Excel file using EPPLUS - Various types of charts using [login to view URL] - XML Parsing to Object and many more... awaiting for positive response. thanks & regards , Gaurav
$50 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
33 фрілансерів(-и) готові виконати цю роботу у середньому за $193 AUD
Аватарка користувача
In one of my previous project, I worked with large amount of XML files that I transfer via ftp to an azure website folder on a daily basis. I was using C# to transfer the data to azure sql server tables. But this was extremely slow. Later, I was trying to run an Azure SQL job to bulk import these files; So I was unsure how to do this in Azure; Later I understand that any T-SQL interface is not supported to read files from blob store or container. So simply I need to push the data from outside of the SQL server; One option is to use Azure Automation to run the code periodically or based on a schedule; And it works actually and is with a speed. Basically data import to and export data from, SQL Server and Azure SQL Database, various methods are available. The methods include Transact-SQL statements, command-line tools, and wizards. Here are various possibilities:- I can import data with the BULK INSERT or the OPENROWSET(BULK...) commands. Typically, need to run these commands in SQL Server Management Studio (SSMS). Also, I can import and export data with the BCP command-line utility. Even, I can import a text file into SQL Server by using the Import Flat File Wizard in SQL Server Management Studio (SSMS). Now, I need a discussion with you regarding this project, Please let me know your convenient time to have a discussion; Need to discuss about few doubts regarding this project. I am available.
$155 AUD за 3 дні(-в)
4,9 (117 відгуки(-ів))
8,3
8,3
Аватарка користувача
Hello Sir I am an expert with Azure and I can help you here. I can provide you a .net program or SQL Scripts to perform the data upload from excel files. Thanks Aanvik
$277 AUD за 3 дні(-в)
5,0 (36 відгуки(-ів))
6,2
6,2
Аватарка користувача
I have worked with hockey statistics before that's why I'm sure you'll be impressed with my work. I can provide you C# program that will read Excel files and upload information into Azure database. All I need to start is your database schema and input samples from you.
$220 AUD за 2 дні(-в)
4,9 (89 відгуки(-ів))
5,7
5,7
Аватарка користувача
Hi, I have experience of working on similar projects, I can help to develop sql procedure to get data from excel and store in azure database. Can you please provide xls file and provide details about tables where you want to store data? Please let me know about time when you would be available so we can discuss further.
$250 AUD за 7 дні(-в)
4,8 (26 відгуки(-ів))
5,8
5,8
Аватарка користувача
Hi, I can develop one window s form using c# which will transfer data to azure. please provide sample data file. I don't have experience in sports industry, but I can do this.
$200 AUD за 5 дні(-в)
5,0 (20 відгуки(-ів))
4,0
4,0
Аватарка користувача
Hello I would be pleasure to help you to do the job. I have worked for 12 years in software development using .net technologies such as VisualBasic, VB.NET, C#, Winform, ASP.NET (Webform, MVC), .NET Core, JQuery, KnockoutJs, AngularJs/ Angular... I am confident that could help you solve this task. Regards // Bien L.
$166 AUD за 3 дні(-в)
5,0 (9 відгуки(-ів))
3,9
3,9
Аватарка користувача
i have very good experience in C3, Azure as well as Azure SQL Database. Currently i am working as a cloud Architect involved in the development of a commercial Web based application architected and hosted in cloud
$155 AUD за 3 дні(-в)
4,8 (4 відгуки(-ів))
4,3
4,3
Аватарка користувача
Hi, I'm an expert in Azure and web applications and provide expert consultation to clients to build, implement, and deploy Microsoft Cloud solutions on Microsoft Azure. I do have expertise in the below mentioned skillset: MS Azure, C#, MVC 5, API, Azure Worker Role, Azure Table Storage, Azure Redis Cache, Azure Service Bus queue, Azure Scheduler, Azure SQL Server Azure Web Apps, MEAN Stack I have been building apps on Azure for the past 3 years helping clients understand the options to streamline implementation including hybrid applications and also by helping clients with Microsoft Azure development solutions and services to create enterprise level applications to automatically scale according to changing market needs and offering expert consultation to clients to build, implement, and deploy Microsoft Cloud solutions on Microsoft Azure. I would be happy to discuss more about your project in detail and I will be looking forward to your response. Thank you, Moble
$250 AUD за 3 дні(-в)
4,8 (4 відгуки(-ів))
4,0
4,0
Аватарка користувача
Greetings! I am an expert Database programmer and I can create an sql file for the task you require with 100% correctness guarantee. Also, I know about the most sports so this will come in handy. Hoping to hear.
$160 AUD за 2 дні(-в)
5,0 (4 відгуки(-ів))
3,7
3,7
Аватарка користувача
Hello, I see you are looking to import an excel file and capture into SQL database having multiple parent/child tables. I can definitely assist you on that. I have already achieved similar tasks which includes Import/Export Excel and CSV files, Provide column mapping to end-users, Perform validations on the imported data, Capture to the database. For your requirement, I will create a single exe project based on C#.NET where you can upload the excel file and upon clicking on Submit button, the application will generate an SQL script file consisting insert statements. So, you can re-use the same exe for similar excel files. Let's go through the excel file and respected sql tables to be captured. Looking forward to hearing from you. Best Regards, Romil
$222 AUD за 3 дні(-в)
4,9 (3 відгуки(-ів))
3,5
3,5
Аватарка користувача
Hi, I can do this work. Individual and hard working person done your work accurately. Waiting your response. Always I do my best & fast with on time delivery for my all clients. Please tell me what you need and how would you like to complete this project. Your project will be 100% accurate and professional. 100% satisfaction guaranteed. Fully clear communication. Continued support after done your project. Please trust me & give the opportunity. I will hope your answer. Send me a message, I’ll respond quickly. Your satisfaction is my success. With Regards!
$250 AUD за 3 дні(-в)
5,0 (6 відгуки(-ів))
3,2
3,2
Аватарка користувача
Hi there, We can create Azure SQL DB schema as per the XLS files you've. Please provide the file to us for review and we'll go from there. Thank you!
$200 AUD за 3 дні(-в)
3,8 (2 відгуки(-ів))
4,4
4,4
Аватарка користувача
Hi, Hope you are doing well. I am C# developer and I can develop you a C# code which will read XLS file and do some data manipulation if require and then push the data into Database server. If your server is on cloud and access able via IP address then you can run this application from anywhere Otherwise need to run on server. I know some terminologies of Hockey Feel free to discuss more or ask any query if you have. Thank you
$222 AUD за 5 дні(-в)
5,0 (3 відгуки(-ів))
2,7
2,7
Аватарка користувача
Sir I have many such type of program for JK PAPER LIMITED on .net and Sql where I’m importing data from excel file to Sql server database. AS PER THE REQUIREMENT OF CLIENT. It will be a easy task for me to do this for you. Looking forward to hear from you
$111 AUD за 2 дні(-в)
5,0 (1 відгук)
0,6
0,6
Аватарка користувача
Hi, I have done something similar, on my previous job, we were receiving xls files with stock prices, and we had to insert them into an Oracle DB. What I did was reading through the file and convert the data into SQL script that contains SQL INSERT statements that maps fields on the xls file to fields on different tables, which we then ran on the DB. It could be also done in a way that it gets inserted straight into the DB giving that the tool have connection to the DB, but in my case, the script had to be checked first before it gets applied, as stock prices are sensitive data. Let me know if you would like to discuss some details. Kind regards Mo
$250 AUD за 3 дні(-в)
5,0 (1 відгук)
0,0
0,0
Аватарка користувача
I have 9 years of experience in SQL Server design, development and optimization. I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012, 2) MYSQL, MS Access 3) Oracle (PL/SQL), 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS.
$155 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i have experience in c#.net with critical sql statements for ,xls file generation also have experiance in creating the application for import xls files into sql tables.
$222 AUD за 10 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Prepare the XLM Process or Stored procedures, could be integrated thru C# in SQL Server o Transact SQL Server, with same type of performance, I would recomend TSQL.
$388 AUD за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
As as the description of the project, data would have to be imported from XLS file to 4 tables of MS SQL Database. However, I would like to have detailed discussion on the requirements to plan and execute the project accordingly.
$222 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Experienced running largest navision database in the us. Experience with sql and oracle databases as well as access. Write SQL queries daily. Played a year of rollerblade hockey in middle school. Relevant Skills and Experience Write sql queries to modify and insert data daily.
$222 AUD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор AUSTRALIA
Camden, Australia
5,0
3
Спосіб оплати верифіковано
На сайті з квіт. 5, 2018

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.