Combining data from 2 linked tables

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?

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

"Keri" <Keri.DeleteThis@discussions.microsoft.com> wrote in message
news:7CEB57B5-ECC4-403D-83C1-C26C7C810940@microsoft.com...
>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?