View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rajesh Rajesh is offline
external usenet poster
 
Posts: 47
Default Excel reporting and database

Hi,

I do many reports in Excel with large volume of data. Current im using SQL
server personal edition to store the data, and make pivot in excel based on
the sql server data. My system OS is XP Professional. But transfering large
voulme of data from SQL server to Excel is time consuming and i feel the
whole system speed brought down.

Can any one suggest what could be the best database i could use for a better
data anyalysis or how i could speed up the process.

Database contains many tables and Views

Rgds
Rajesh