Find Jobs
Hire Freelancers

Create 2 Powerpivot Files from MS Access and CSV Files

$10-30 USD

Closed
Posted about 10 years ago

$10-30 USD

Paid on delivery
MUST HAVE EXPERIENCE WITH POWERPIVOT, EXCEL, ACCESS, AND CSV FILES. MUST HAVE A VERY POWERFUL COMPUTER OR SERVER TO DO THIS. I need to be able to manipulate/sort etc. the powerpivot data after you create the files, so if it is not possible to do from my computer. I have 2 sets of files that I need to be converted into 2 separate Powerpivot Files. PART 1) I have four files (CA1, CA2, CA3, CA4) each with about 5 million rows of data. I want you to create a single Microsoft Excel Powerpivot file (and I want you to call it "ALL CA") with these files. In each of the CA files (CA1, CA2, CA3, CA4) there is a column labeled "Prop_id" with a 9 digit number in each row. I also have a Microsoft Access file called "Owners" with a column labeled "Prop_id" and "Owner_nam". I want you to create a new column in the "ALL CA" file and call the column "Names". In the "Names" column I want you to import the corresponding "Owner_nam" in the "Owner" file that matches the "Prop_id" in the "ALL CA" file. FILES FOR PART 1 [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] PART 2) I have a CSV file labeled "AllTXUP" and I want you to create a powerpivot file labeled "ALL TX". FILE FOR PART 2 [login to view URL] Please download and look at the files so you can see what needs to be done. If you've read these instructions and you're interested in bidding, type these exact words in the beginning of your message so I know you're not a computer: "Hello EJacobs". Also let me know how long this will take you. I'm looking for somebody to do it in less than a day.
Project ID: 5370645

About the project

6 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $26 USD for this job
User Avatar
Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this. Regards
$29 USD in 1 day
4.9 (33 reviews)
4.7
4.7
User Avatar
Sir I'm expert on Powerpoint and i have done many project like this . I will give you best quality and design. Looking forward working with you. I'm ready to start now . Thanks
$30 USD in 1 day
5.0 (9 reviews)
3.9
3.9
User Avatar
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
$24 USD in 1 day
5.0 (9 reviews)
2.7
2.7
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Los Angeles, United States
4.9
37
Payment method verified
Member since Apr 6, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.