Is a SQL server my answer??

By dmalbrough ·
I currently use several Pivot Tables in Excel to link to Access tables and queries. The Access tables are very large and it's becoming cumbersome to work with the Excel files that are linked. Ex. An Excel pivot that's linked to a 700K row access table is 250MB big, and I don't want to filter the access table because I use all the data through several reports in Excel. I'm trying to figure out if I can shift the reading and functionality the pivot table goes through to access the table in Access. I would like to shift this process to something more powerful like a SQL server. Do you know if this is possible?? My IT guys are telling me that it is but I'm not sure if we are talking the same language. Basically, I want a more powerful Pivot table that can link to several hundred thousand lines and can retrieve the data easily, while at the same time, only creating an Excel file that is as big as the data that is being viewed. I hope that makes sense. I'm really interested in answering this question that I've been having for a few years now. Can you help???? Thanks

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums