Hi I'm having problems working with data adapters and datasets... Simple program of just transfering data from MS SQL to MS Access using loop... in vb 6 i use this codes could someone create a VB.net version using ADO.NET?'Assuming rsSQL is connected to MS SQL DATABASE'and rsAccess is connetcted to MS Access 2000 Databasedo while not rsSQL.eof rsAccess.AddNew rsAccess!FName = rsSQL!Fname rsAccess!LName = rsSQL!Lname
rsAccess.Update rsSQL.MoveNextloopI hope someone can help me....Please, please please.....Thanks a lot...