If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Combining data from 2 linked tables
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" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|