Loading

Import millions of records from database to excel !!

s s

Hi
I have this requirement of importing millions of records from database to excel sheet ,within very less time . Can some body provide me with some approach or some code to help me?

The code has to be in VB .net or C#.

Thanks for your patience

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

s s19y ago
Hi Scott
Thanks a lot for responding.
I am working with ver. 2000 . The requirement is to dynamically load 65,000 rows of one grid ,then create and load the other grids till the data has been loaded fully.
How can I do this using the Filestream object ?
Scott Lysle19y ago
Well, if you are working with the pre Office 2007 version of excel, you are not going to be able to load more than 65,536 rows into the excel grid because that is the limit. In 2007, you can load 1,048,576 rows. In either case, you can't load millions of records into a single excel grid.

You can write what you can into one grid and start another and repeat the process until run out of grids.