I have imported an Excel spreadsheet in MS Access and reorganized it so it looks very similar to the original Excel spreadsheet.
That is good!
However, there is one additional thing the client wants and I need help on achieving it.
The MS Access table is quite large - it i really made up of what looks like several tables.
That is the issue - I want to use queries and break this table up into a collection of smaller tables.
I think it can be done with queries, but I am unsure how to do it.
Of course, each new and smaller table should have a name.
Can this be done? Is there an easier way to do it? Something that would not use queries?
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed