Avatar of rogerdjr
rogerdjrFlag for United States of America

asked on 

Migrate a "3-D" Spread sheet to an Access Database

I have a working project management Microsoft Access database that I continue to develop, adding new processes that help  consolidate all projec t functions into one tool where I can combine data to generate composite reports  

With each new process I learn new techniques

The latest element that I am trying to add is mimicked in the attached spread sheet - the challenge I am faced with is that each contract has a different menu of "Billing Code / Activities" (Column b-f) and then there are monthly billings that occur for the life of the project (col g-o, col p-x, ...)

The typical working spreadsheet has a number of other tabs - but this is the "core data" for each contract.

Currently I manually build the spreadsheet for each project and then manually migrate data from the spreadsheet to my database each month.

Does any body have an example of a "3-d" table structure I could use as a starting point?
PAY-Application-Review-Sample.xlsm
DatabasesMicrosoft AccessMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
rogerdjr
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of rogerdjr
rogerdjr
Flag of United States of America image

ASKER

Thanks

A great help in getting me started
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo