On Wed, 23 Jun 2004 13:02:01 -0700, "Frans Vander Meiren" <Frans Vander
Meiren (AT) discussions (DOT) microsoft.com> wrote:

¤ Hi
¤
¤ Anyone who can explain me how to load and edit an Excel-file in a DataGrid via an odbcConnection?
¤ Thanks

The following should get you started:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Book20.xls;Extended Properties=""Excel 8.0;HDR=NO"""

Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString )
ExcelConnection.Open()

Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from [Sheet8$]", ExcelConnection)

Dim ds As New DataSet("Workbooks")

da.Fill(ds, "Sheet8")

DataGrid1.SetDataBinding(ds, "Sheet8")


Paul ~~~ pclement (AT) ameritech (DOT) net
Microsoft MVP (Visual Basic)