Filestream object (Performance Issue)
Hi
Can some body suggest me which approach I should follow to import millions of records from data base into an excel sheet?
I am working with ver. 2000 of MS-Excel . The requirement is to dynamically load 65,000 rows of one excel-grid ,then create and load the other grids till the data has been loaded fully.
How can I do this using the Filestream object ,in a very short span of time like 1-2 seconds?
Thanks for you patience