Closed

Transfer old data from Excel into new SQL Server database

This is a data cleaning and transfer project. The task is to transfer data from an Excel workbook into a SQL-Server database. The Excel workbook contains data from several tables of an old Customer database. Using a computer program, we have processed this old data and put them into columns which resemble the columns in the new SQL-Server database. The data have also been half-cleaned using the program.

Your job is to do the final clean up of the source data and to upload this data into SQL-Server tables. If the data are not properly formatted and fully cleaned the upload will fail. This is why you must upload yourself into SQL-Server (we will provide access to you via Internet). You must not remove any data, you must maximise the data transferred from the old system into the new.

The Excel workbook has 4 main worksheets: Customers, Purchase Contracts, Purchase Items and Payments. The Customer worksheet has already been completed. Your job are the remaining three worksheets. The workbook has 300 Purchase Contracts, about 500 Purchase Items and about 5,000 Payments.

We have about 25 such data sets, but you are bidding here only for the first one.

You will have up to 7 days to process this first set and about 3 days for each of the following data sets. A rough estimate of the time required is 20 hours per data set.

If you are short-listed on this project, you will receive further details of data, to get a better idea of the amount of work and to adjust your bid accordingly.

This is a basic level work, which requires no special Excel skills, but it requires you to be organised, persistent and very, very tidy.

Please supply any references for similar work done before (person name and email/phone).

Skills: Data Entry, Data Processing, Excel

See more: excel workbook, upload yourself, process data entry computer, old database, name transfer, first source data entry, excel special, data entry worksheet, database entry job level, sql server database, sql server job, job contracts, final data, customer data excel, old bid, database required excel, data upload excel, data transfer email excel, data source sql, data entry sql, any data, short excel task, excel contains, sql final, job idea data entry

About the Employer:
( 14 reviews ) Surry Hills, Australia

Project ID: #2561804

33 freelancers are bidding on average $89 for this job

mantislin

Hi sir, please check pm.

$30 USD in 1 day
(44 Reviews)
5.7
becomeexpert

I am expert on mysql server, I can create table on sql, can insert data properly in each column of a table and i am expert on excel so i can transfer your excel data to a sql database easily. I am waiting for your sele More

$30 USD in 3 days
(29 Reviews)
5.4
Krusche

Our solution offering is to automate this process. Based on the requirements on the data in the SQL DB (format, length) it is a rather simple task to write a macro on validating the data in MS Excel or making some tran More

$240 USD in 7 days
(21 Reviews)
5.2
srinichal

I can deliver script to your specs

$180 USD in 5 days
(13 Reviews)
4.8
fancywwh

I like the DB work very much, PM for detail.

$30 USD in 2 days
(14 Reviews)
4.9
wasimsohail

Consider it done ... Check your PM.. thanks

$150 USD in 6 days
(31 Reviews)
4.8
ExactSystems

Please see detail on PMB regards

$250 USD in 7 days
(5 Reviews)
4.7
rengrish

5+ years of experience in Excel & SQL Please check your message box.

$40 USD in 2 days
(28 Reviews)
4.3
datasolutionind

Let's Start.......

$30 USD in 1 day
(17 Reviews)
4.2
naveenvarthaan

Hi Zoranm0, I am Microsoft SQL Server Database Administrator. Please check my attached Microsoft Certificate. This kind of work is my daily job. Just one questions from my end: Whats the version ? Is it SQL 2 More

$30 USD in 1 day
(13 Reviews)
4.2
ummednegi

I can this project very honestly, Please provide details, I'll do start it. Awaiting for your reponse...Thanks

$60 USD in 5 days
(13 Reviews)
3.8
ExtraNet

Expert in MSSQL, Excel and data processing, please take a look at previous work/exams/etc and let's discuss further.

$30 USD in 3 days
(6 Reviews)
3.7
NourElDeen

Dear Sir, I'm Expert On SQL. Best Regards, NourElDeen

$30 USD in 3 days
(6 Reviews)
3.0
Adnan853

Ready to start now. Please check pmb.

$160 USD in 8 days
(5 Reviews)
2.8
rakeshmaurya1980

Hi - I can do this job very easily and proficiently. Regards, Rakesh

$100 USD in 4 days
(0 Reviews)
0.0
dbland1026

I'm very familiar with sql and excel. Let me know if you are interested.

$50 USD in 3 days
(0 Reviews)
0.0
ganesharun77

I have been involved in lots of Data migration of large data set into various data sources. I have experience in data migration using 3rd party tools from any source to any detinations .

$150 USD in 10 days
(0 Reviews)
0.0
AliSafder

Dear Sir, I have been in databases (like Sql Server, Oracle, Microsoft Access etc.), Programming Languages (VBA used in Microsoft Office products, .Net technologies(Asp.Net, Vb.Net / C#.net, mvc, wcf, ajax, jq More

$70 USD in 7 days
(0 Reviews)
0.0
joserarodrigues

I have 15 years experience in design and maintenance of sql server databases (from 6.5 to 2008 r2) and Reporting (Crystal Reports initially and Reporting/Analysis Services for the last 3 years).

$60 USD in 2 days
(0 Reviews)
0.0
mihiHarshana

Hi I would like to take this opportunity to make your work success. Hope to hear from you Thyank you

$50 USD in 2 days
(0 Reviews)
0.0