Excel use mdb as backend file very large

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Thread Tools

Display Modes

hkappleorange

Posts: n/a

Excel use mdb as backend file very large - 10-12-2005 , 08:31 AM

Hi I am using mdb as database and use Excel Pivot Table to connect to mdb
using ODBC connection.

However, I found as the database becomes bigger, the file size of the Excel
front end also becomes bigger and bigger.

Apart from creating cube, any other solution to this ??

Help...

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off