A
Austen
I need to do some anaylsis work on an Access table hopefully in Excel.
The problem is that the amount of rows prohibits me from importing it
(145,000 rows). The data is grouped by month in Access, so one thought
I had was to import the data by month into a tab for each and then find
a way to use an input box for the user to enter the data requested.
Once requested, go to each tab, pull the data from each tab and present
it with a line graph or something. I have no idea how to begin to do
something this complicated so I am hoping someone has encountered this
before or could at least point me in a direction or suggest a better
way. Thanks.
The problem is that the amount of rows prohibits me from importing it
(145,000 rows). The data is grouped by month in Access, so one thought
I had was to import the data by month into a tab for each and then find
a way to use an input box for the user to enter the data requested.
Once requested, go to each tab, pull the data from each tab and present
it with a line graph or something. I have no idea how to begin to do
something this complicated so I am hoping someone has encountered this
before or could at least point me in a direction or suggest a better
way. Thanks.