how to create a query in Access that combines headings and a list of dates into a single table

I'm attaching a file with a list of headings and a set of dates. I used Power Query to assemble the Final Result sheet. This works fine. However I now have a scenario where I have to do  this for 5 years data and about 200 customers and it was exceeding Excel's capacity. My plan is to create the full version of this Final Results sheet but in Access. So how so I combine a file that has dates running from 1/1/2013 to 31/12/2018 with a file that has headings columns A to H (Starting point sheet) to generate what I have in the Final results sheet. Basically how do I create a query that combines these two data sets into a table (that I can then pull into a Powerpivot model - that's how I'm planning to go at the moment) .
EE_Access_question.xlsx
LVL 1
agwalshAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Access tables have header for any column. It should be enough for your aims. Append query in Access (or even copy/paste) can combine many tables into one). Will be better for you to start process in Access and ask questions when you will have any problem. Start from importing data from Excel to Access
0
agwalshAuthor Commented:
Went a different route in the end. Created it in Power Query and then just loaded it as a connection into a PowerPivot model.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
als315Commented:
Author find solution himself
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.