Transfer old data from Excel into new SQL Server database

ปิด โพสต์แล้ว Oct 12, 2012 ชำระเงินเมื่อจัดส่ง
ปิด ชำระเงินเมื่อจัดส่ง

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).

คีย์ข้อมูล การประมวลผลข้อมูล Excel

หมายเลขโปรเจค: #2561804

เกี่ยวกับโปรเจกต์

31 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 31 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $93

mantislin

Hi sir, please check pm.

$30 USD ใน 1 วัน
(196 รีวิว)
7.3
datasolutionind

Let's Start.......

$30 USD ใน 1 วัน
(84 รีวิว)
6.0
rengrish

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

$40 USD ใน 2 วัน
(166 รีวิว)
6.0
tonmay

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 เพิ่มเติม

$30 USD ใน 3 วัน
(30 รีวิว)
5.4
srinichal

I can deliver script to your specs

$180 USD ใน 5 วัน
(29 รีวิว)
5.5
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 เพิ่มเติม

$240 USD ใน 7 วัน
(21 รีวิว)
5.1
wasimsohail

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

$150 USD ใน 6 วัน
(31 รีวิว)
4.8
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 เพิ่มเติม

$30 USD ใน 1 วัน
(23 รีวิว)
4.6
ExactSystems

Please see detail on PMB regards

$250 USD ใน 7 วัน
(5 รีวิว)
4.6
ummednegi

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

$60 USD ใน 5 วัน
(14 รีวิว)
4.0
NourElDeen

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

$30 USD ใน 3 วัน
(10 รีวิว)
3.4
Adnan853

Ready to start now. Please check pmb.

$160 USD ใน 8 วัน
(6 รีวิว)
2.7
freeravi

Ready to wrok

$200 USD ใน 10 วัน
(0 รีวิว)
0.0
llazzaro

Hello I think I can provide a script for automate the process. however I need more information. thanks!

$60 USD ใน 2 วัน
(0 รีวิว)
0.0
Prabkumar

We run a data entry company with skilled people infuse. Your job will be done as we see a long term relation here beneficial to both based on the project details you have provided.

$200 USD ใน 7 วัน
(0 รีวิว)
0.0
Maxi07

Ready to start now!

$250 USD ใน 3 วัน
(0 รีวิว)
0.0
shalinjee

Hi I am waiting to work with you

$100 USD ใน 5 วัน
(0 รีวิว)
0.0
donhuan

Dear Hiring Manager I'm very interested your job. I guarantee to complete your job well. Can i start? Best Regards, do-nhuan

$90 USD ใน 7 วัน
(0 รีวิว)
0.0
iqrarahmed

asslam u alikum i will do this for you GIVE ME OPPERTUNITY FOR THIS

$30 USD ใน 10 วัน
(0 รีวิว)
0.2
robbywh

Hello sir. I usually do a data migration in excel into MSSQL 2008 at my office. I think i can do this job and i will do my best. Thank you

$60 USD ใน 2 วัน
(0 รีวิว)
0.0