Combining data from 2 linked tables

[Keri]

I am working on a spreadsheet that ran out of room on the first worksheet, so
I had to open a second worksheet to continue keeping data.

I need to use Access to take the data from both worksheets and create one
table. I will be using the new table to create reports, pivot tables,
charts, etc. I linked the 2 worksheets to Access and now I am stuck. (FYI -
there are 147 columns too, so this is big.)

What do I do?

 

[Jeff Boyce]

Keri

It is common to link to/import Excel spreadsheets into Access. However, you
are not limited to keeping your final version of the data in that same
format (Excel spreadsheets are usually not well-normalized -- Access EXPECTS
well-normalized data).

Consider creating a well-normalized data structure (yes, 147 columns is very
likely not even normalized <g>), then creating queries that take data from
the Excel versions and parse it into your well-normalized structure.

Then you create your queries against that well-normalized (and more
permanent) table structure.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP