[amirsarb]

I have written a program in vb.net 2005 that takes data from Excel files.
I get the data from the files using OleDbConnection and calculate data with Select query.
My question is:
This is a very time-consuming process, and often not work, when i use a excel file about 29000 record and use select query.
Is there a faster way?

code:

 Dim MyCommand As System.Data.OleDb.OleDbDataAdapter

            MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & FilePath & "';Extended Properties=Excel 8.0;")

            MyCommand = New System.Data.OleDb.OleDbDataAdapter _
    (query, MyConnection)

            MyCommand.TableMappings.Add("Table", "TestTable")

            Dtset = New System.Data.DataSet
            MyCommand.Fill(Dtset)

            DataGridView1.DataSource = Dtset.Tables(0)

            MyConnection.Close()

Mod Edit: Please use code tags when posting your code. Code tags are used like so =>

Thanks,
PsychoCoder

[PsychoCoder]

VB 2005 is VB.NET so I'm moving this to the VB.NET forum