This is a data cleansing project in Excel.
The task is to transfer data from one Excel spreadsheet to another. The first spreadsheet contains tables from an old MS Access database, one worksheet is one table in MS Access. The second spreadsheet contains templates for the new SQL Server database, one worksheet is one table in the SQL Server.
You need to transfer data from the Source Spreadsheet (SS) to the Destination Spreadsheet (DS), column by column. This process cannot be fully automated, because the data in the SS must be cleaned before being transferred to the DS. Therefore, the data should be transfer column by column, with clean up and check up.
The SS workbook has about 30 worksheets, the DS workbook has about 8 worksheets.
The SS workbook contains worksheets of Customers, Stock Items, Purchases etc. There are about 300 customers, 500 Items and 500 Purchase Invoices. The total size of SS in Excel is about 1 MB.
It took me about 20 work hours to do the first such transfer myself.
This project is for one transfer from SS to DS, but we have about 40 identical projects. If your performance on the first project is good, then you may be invited to continue this work over the next two months.
If you are short-listed on this project, you will receive the SS and DS without data but with a count of records in each, 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 from you to be persistent and very, very tidy. The criterion of your achievement is how easily and quickly your DS can be imported into SQL Server. If SQL Server rejects your DS and I have to do many corrections, then you have not done your job well.
Please supply any references for similar work done before (person name and email/phone).
Sir/Madam,
It is our pleasure to be able to bid on your project.
I would like to give my fullest and maximum contribution towards the success of this project. Anticipating your favorable reply.
For further reference please have a look on PM for details.
Thanks
tmoi06
Hi,
I have gone through your requirement and I am glad that We can accomplish
this task, Please give us opportunity to work with you.
Please check PM .
Thanks,
TTS Team
Hi tdooleylokkob ,
I am a database administrator.
I am Microsoft certified professional in SQL server. I can complete this task with ease for you.
I can even assist you in importing data into SQL server. I can send you final data in excel or SQL database (mdf and ldf) format so that it will be easy for you.
Send me sample access DB or excel doc, i shall send the ouput in a format which you can easily import to SQL server
Waiting to hear from you.
Hope we shall work on this together
Thanks,
Naven
I would be very interested in completing this project for you. I am able to start immediately. I have extensive knowledge and experience in transfering files from databases and creating Excel documents from the information. I would require an example of a completed spreedsheet in order set the spreedsheet up correctly.
Im articulate, can work 4 hours a day, very keen to details, Computer Science graduate, has working experience, can handle pressure with minimal supervision, reliable, has laptop, and can work immediately.
Currently i am working as a software engineer. Data entry is my part time job. i can able to do it with the very quality work. Please i am awaiting for your reply. i ll do it per day 5 working hours for this work.
The underlying goal of this project is to populate SQL Server tables with data from excel sheet and that too without any errors. I have worked on pulling data from excel to SQL Server in the past. I have used SSIS tool of Microsoft to do that job. Although it does not require deep excel knowledge but i possess that also.
Well, I have experience in upgrading data design for a company and managing data for 3 years. I costs you a cheap for yours. Please accept my bid. Thanks
I have done this before and i know what you are looking for. You say that it doesn't need any excel skill but I have been working on excel in about 10 years.
I am very willing for that kind of work.
Take care:)