Completed

Import a batch of Excel spreadsheets into a SQL server database

I have a collection of 300 Excel spreadsheets (800MB) that I would like imported into a SQL server database. I will provide access to the SQL server database. - Each sheet has to be named to match the file name it is was imported from.

This may need some form of automation, since there is a lot of data.

The terms of payment is as follows;

1. I will set a 50% milestone payment when you have imported 1 spreadsheet - this is to demonstrate that you know how to use SQL server.

2. I will release the 50% milestone once 100 the excel spreadsheets have been imported

3. I will release the final milestone when all spreadsheets have been imported.

4. I do not release payment in advance, please do not ask.

5. What you bid, is what I pay, please do not ask for more money than your bid.

Skills: Database Administration, Excel, Microsoft SQL Server

See more: excel import sql server, excel import spreadsheet keep attribute, sql 2005 create job import excel spreadsheet sql, power point, articles, data processing, c# programming, sql, excel, database administration, microsoft sql server, visual basic for apps, sql server excel import slow, sql enterprise edition excel import, upload excel database sql server using, insert xml database sql server using vbnet, php class excel import database, converting access database sql server, automatic backup sql server database, net client code connect sql server database

About the Employer:
( 12 reviews ) Derry, United Kingdom

Project ID: #13128567

Awarded to:

mahmoud249

Hi . l have great experiences dealing with Excel and SQL Server I read the job description, it is in my interest field check my profile on upwork([login to view URL]~01d983171a640501d6?viewMode=1) More

$30 USD in 4 days
(3 Reviews)
1.9

71 freelancers are bidding on average $168 for this job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$100 USD in 1 day
(188 Reviews)
7.1
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the informatio More

$100 USD in 3 days
(202 Reviews)
7.2
sumon355

Hello, I am very much interested to do this work by .Net as i have similar working experience. Does it need to import the files in separate tables or there would be a common table for all files? Looking forward to hav More

$140 USD in 4 days
(82 Reviews)
6.7
DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I have plenty of experience with SQL, which is why I am positive I can do the bulk upload that you need. I do not ask for payment in ad More

$199 USD in 3 days
(75 Reviews)
6.6
deepabittu

Hello Sir, I have 5+ member team i am done this type job last time with good result so plz give me one chance so i am done this job with good [login to view URL] Regards

$111 USD in 1 day
(168 Reviews)
6.2
dpune

Hi, I have more than 14 years of SQL Server/Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 project More

$250 USD in 10 days
(121 Reviews)
6.3
safiqulislam67

Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu More

$80 USD in 3 days
(110 Reviews)
6.4
pandey2008

Hello sir,we have 8 member team and we can start work right now just give us one chance we will do our best,awaiting your [login to view URL]

$88 USD in 1 day
(222 Reviews)
6.7
nazmulcb

I am very professional data entry and web researcher on freelancer.com. Here I completed a lot of project with good reputation. Very motivated, honest and hard worker. This is my main profession. So I take this serious More

$50 USD in 10 days
(38 Reviews)
5.3
paskal77

Hello Sir /Ms, I have received the specification of your project and I am sure to be able to develop it, What kind of solution do you require? ETL, or windows application? Please check the past projects that More

$50 USD in 3 days
(37 Reviews)
5.1
mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. Being experienced in working on excel and sql server database and have experienced in exporting/importing data to and More

$127 USD in 3 days
(42 Reviews)
5.1
IMExpertEngineer

Hello, I'm ready to do this import data into sql server , please share the excel file and do let me know if all of files have same structure and needs to be added in same table or there are some other requirements. More

$277 USD in 3 days
(6 Reviews)
4.7
jagdishbhatt38

I am having more than 7 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 More

$250 USD in 7 days
(19 Reviews)
4.7
vinaysinghh

A proposal has not yet been provided

$555 USD in 15 days
(32 Reviews)
4.9
$100 USD in 1 day
(8 Reviews)
4.3
sheikDev

Hello, I'm interested to work on this. can you share the sample excel sheet and table schema.. Im agreed with your terms. Thanks, Sheik

$124 USD in 5 days
(13 Reviews)
4.3
weng0000

Good evening! I can help you do the importing of 300 excel spreadsheets to mssql sql server database. Can you provide me a sample excel spreadsheets and the tables that I can going to import so that I can review and More

$277 USD in 3 days
(13 Reviews)
4.2
Splaszczyk

Hi. This task looks to be implemented in a fairly simple way using INTEGRATION SERVICES ( SSIS ) and foeach loop. Hope you have this service installed or got a possibility to install on your SQL Server machine from ins More

$222 USD in 10 days
(3 Reviews)
4.2
kayamoako

Hello, I have over 5 years experience as a Full-Stack C#/.NET developer, predominantly working with WPF, ASP.NET, web technologies, and web design.* I project as you have just described is right down my alley, I h More

$250 USD in 1 day
(3 Reviews)
3.7
codetastic

Hello, I am an experienced PHP / Python developer with expertise in data processing automation. Please contact me with further details. Regards, Erik

$180 USD in 3 days
(5 Reviews)
3.9