Hi All,



Can someone please provide me with a tip on how can i upload a file from excel going to database in a faster way.

I have an excel file that contains 400,000 record.The only problem that i am facing is that, the system took an hour before everything is uploaded in the database. is there a way that i can minimize the time it uses because i find it inefficient.



Thanks.

Dim con As New OleDbConnection

Dim cmd As New OleDbCommand



con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\book.accdb"

con.Open()

cmd.Connection = con

cmd.CommandType = CommandType.Text

cmd.CommandText = "select * into newxl2 from [Excel 8.0;HDR=YES;DATABASE=E:\vbexcel.xlsx].[Sheet1$] s;"

cmd.ExecuteNonQuery()

con.Close()

vbexcel is the excel file name and newxl is database table which is created by programatically..

thank you for this reply.. im already done with this project but i will look into your idea and compare which is the fastest..