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.
61 freelancere byder i gennemsnit $406 for dette job
Hi, I can do the job, MS Access Expert, I understand your requirements and I can develop the database that you are looking for I am looking forward to work with you
Hi.. Expert database developer here. Assure you accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards
I have many years experience with Access, SQL Server and other database systems. I also have experience of data import from CSV files (and Excel). Please see your PM for more details.