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, data data sql, upload yourself, process of data entry in a 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 database in excel, customer data in excel, old bid, excel to sql, database required in excel, data upload from excel, data transfer from email to excel, data source sql, data entry SQL , data clean-up, any data

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

Project ID: #2561804

33 freelancers are bidding on average $89 for this job


Hi sir, please check pm.

$30 USD in 1 day
(44 Reviews)

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)

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)

I can deliver script to your specs

$180 USD in 5 days
(13 Reviews)

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

$30 USD in 2 days
(14 Reviews)

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

$150 USD in 6 days
(31 Reviews)

Please see detail on PMB regards

$250 USD in 7 days
(5 Reviews)

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

$40 USD in 2 days
(28 Reviews)

Let's Start.......

$30 USD in 1 day
(17 Reviews)

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)

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)

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)

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

$30 USD in 3 days
(6 Reviews)

Ready to start now. Please check pmb.

$160 USD in 8 days
(5 Reviews)

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

$100 USD in 4 days
(0 Reviews)

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

$50 USD in 3 days
(0 Reviews)

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)

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 /, mvc, wcf, ajax, jq More

$70 USD in 7 days
(0 Reviews)

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)

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)