Transfer old data from Excel into new SQL Server database
$30-250 USD
Dibayar saat pengiriman
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).
ID Proyek: #2561804
Tentang proyek
31 freelancer rata-rata menawar $93 untuk pekerjaan ini
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 Lebih banyak
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 Lebih banyak
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 Lebih banyak
I can this project very honestly, Please provide details, I'll do start it. Awaiting for your reponse...Thanks
Hello I think I can provide a script for automate the process. however I need more information. thanks!
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.
Dear Hiring Manager I'm very interested your job. I guarantee to complete your job well. Can i start? Best Regards, do-nhuan
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