Sedang Disiapkan

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

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: creating database monthly reports, project using access excel, create multiple access files, excel create access database, create access database monthly, access database data month, monthly database excel, ways represent data, ways freelancer, want create database, set freelancer account, search microsoft freelancer, reports freelancer, point care data entry, microsoft project import, microsoft project freelancer, microsoft excel help 2013, want create freelancer account, want freelancer database, freelancer microsoft access, freelancer data visualization, find freelancer access database, event freelancer database, db freelancer, data visualization freelancer

Tentang Majikan:
( 0 ulasan ) Indonesia

ID Projek: #4094634

Dianugerahkan kepada:


Please check PMB

$15 USD / jam
(0 Ulasan)

3 pekerja bebas membida secara purata $15/jam untuk pekerjaan ini


Need more details

$15 USD / jam
(6 Ulasan)

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

$15 USD / jam
(8 Ulasan)