Create Microsoft Access database using multiple Excel files (monthly reports) - repost

In Progress

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.

Skills: Data Entry, Data Processing, Excel

See more: create access database multiple excel files, create microsoft access database multiple excel, creating database monthly reports, project using access excel, create multiple access files, create report access excel file, excel create access database, create access database multiple excel, create access database using excel files, access create report multiple excel files, create access database monthly, access database data month, monthly database excel, ways to represent data, ways to be freelancer, want to create my own database, to create freelancer account, set up freelancer account, search microsoft freelancer, reports freelancer, point of care data entry, microsoft project import, microsoft project freelancer, microsoft excel help 2013, i want to create freelancer account

Project ID: #4094634

Awarded to:

zahidrose

Please check PMB

$15 USD / hour
(0 Reviews)
0.0

3 freelancers are bidding on average $15/hour for this job

cosconeaionut

Need more details

$15 USD / hour
(6 Reviews)
3.6
eugene2006

Hi. Can you give me an example of monthly report?

$15 USD / hour
(8 Reviews)
3.3