Zino,
Read your Excel file in a dataset using this kind of code (Sheet1 can be
another name)
\\\
Dim ConnectionString As String
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\test1\myExcel.xls;" & _
"Extended Properties=""Excel 8.0;HDR=NO"""
Dim Conn As New System.Data.OleDb.OleDbConnection(ConnectionString )
Dim da As New System.Data.OleDb.OleDbDataAdapter _
("Select * from [Sheet1$]", Conn)
Dim ds As New DataSet
da.Fill(ds, "Sheet1")
///
Than change the names of the columns in your dataset to the columns in your
database table, open a connection in your database, create a dataadapter and
do a fillschema.
http://msdn.microsoft.com/library/de...chematopic.asp
Than you can even use the commandbuilder (I am not sure of this so you
should try that and otherwise create your own updatecommand) and do an
update of that dataset in the database
I hope this helps?
Cor