Analyze Access table

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.
 
D

Dave Patrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Compile Data from Different Sheets 2
Best way to get data from Access 2003 to Excel 2003 6
How do i write data from Excel to a table in Access (2007)? 4
Pivot table not recognizing same field values 1
help needed! excel formulas above my head! 2
Macro Debug on Pivot Table 5
Macro for Auto Fill 1
Table Data Entry from Form 2

Top