Analyze Access table
 

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.

Analyze Access table
 

Why not do it all in Access? Or at least the user input form to setup the
query, then use the TransferSpreadsheet method to export the result to
Excel.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Austen" wrote:
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.