0

I want to export my database selected information into word 2003/2007.
If i use below code then it takes more time [10 minutes] for 20000 records to display.

Is there any other way to display 20000 records into word 2003 /2007 within 10/15 seconds

Dim ds As New DataSet
        dscmd.Fill(ds)

        For i = 0 To ds.Tables(0).Rows.Count - 1
            For j = 0 To ds.Tables(0).Columns.Count - 1
                oTable.Cells(i + 1, j + 1) = _
                ds.Tables(0).Rows(i).Item(j)
            Next
        Next

Please help me out .

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

3
Contributors
6
Replies
7
Views
5 Years
Discussion Span
Last Post by G_Waddell
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.