Quick Question

[lothos12345]

I have developed an Application in VB 6.0 that updates records in an Access Database from an excel spreadsheet. I am developing a similiar application in VB.NET. In 6.0 the code was like the following:

 

rst.fields("somefield") = excel.cells(1,1)

 

My question is since VB.NET no longer uses a recordset instead it uses a data set what would be the correct syntax to get to update the records.

 

Any help with this question would be greatly appreciated.

[Robby]

You can continue to use ADO in .NET if you wish.

If you want to start with ADO.NET, there is much to learn, here's a start....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/adonetprogmsdn.asp