Create Microsoft Access database using multiple Excel files (monthly reports) - repost
This project was awarded to zahidrose for $15 USD / hour.Get free quotes for a project like this
Project Budget$15 - $25 USD / hour
I need to create a database from a monthly excel file.
Input Information - I have a monthly report that has fixed columns of data. This rows in the report are accounts. The columns represent information about each account. Some columns do not contain information I care about, and could be ignored. There are approximately 5 years of data I would need to import when the DB is set up. The files are text files, but come into MSFT Excel easily (comma delimited).
Output or Visualization - I need to be able to look at the data in two ways. First is to look at each account, and track changes in the values. The values will have single event changes (i.e. they do not change month to month). Changes themselves are the events I want to be able to find. Also, I need to be able to look at a column (i.e. a specific data point) to search for changes over time to those fields. I do not own MSFT Access, but could purchase for this project.
This is a personal project, so I have a budget. The "added value" of a freelancer is knowing what I am trying to do with the data, and creating easy ways to search and visualize the data (changes in data really) that help me with my larger project.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online