Problem in exporting large data into excel

deedi

Hi,

I've a problem with exporting my query results into excel. When the rows returned are less, export to excel is happening without any issues. When there is large number of rows, IE is showing an error message like "Internet Explorer cannot download file from site. IE was not able to open the internet site. The requested site is either unavailable or cannot be found. Please try again later."

Kindly help me in this regard.

Regards,
Deedi

Mar 18 '08 #1

jhardman

Excel is probably generating an error. There are several size limitations in excel (the amount of data in a single cell, the number of columns, the number of rows, etc) and you are probably trying to put too much information in. How much are you trying to put in it? Does it fit when you try to put it into excel manually? Is Excel really the best file format for the information you want to display?

Jared

Mar 23 '08 #2