wow ... 1 million records in Excel...
for what purpose are you loading this type of data into Excel? DataTransfer
/ DataAnalysis / Cause you want to build a huge excel file???
maybe you can do it with more logical work chunks? But a million records...
You will have to manually code the copy / insertion of these records into
excel ... ie retrieve 64000 records ... write 'em ... retrieve 64000 records
.... write 'em ... and so on... OLE Excel or ODBC connection to excel come to
mind... I bet you will need a lot of system resources ... i have never
tried it, but when working with Excel and 'large' datasets (small in
comparison to your requirements) i know excel starts to lag a bit.
but to be honest, i doubt there is a quick way to load 1 million records in
to Excel!
Jeff.
"hyper-sensitive" <12**********@gmail.comwrote in message
news:11*********************@q2g2000cwa.googlegrou ps.com...
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 to one excel-grid(worksheet) ,then create
and load the other grids(worksheets) till the data has been loaded
fully.
How can I do this using the Filestream object ,in a very short span of
time like some seconds?
Here, coding is not a problem .I am unable to get things done in a
small time limit hence Performance is the issue.
Thanks for you patience