Downloading question

[lothos12345]

Like before I am using VB.NET to download excel into access. The problem I am running into is figuring out how to get it to move to the next record. For example I want the program to keep pulling in data from excel until the text "end" is located in the 1 column. However, I cannot figure out how to get the program to move to the next record in Access. Any help with this question would be greatly appreciated.

 

[Robby]

What method are you using?

 

[lothos12345]

Method

I am using of course the dataset, oledataadapter, and oleconnection1. However I am not using them in code, I am using the controls .NET provides to use them.

 

[Derek Stone]

The "next record" exists, correct? If youre converting an Excel spreadsheet to an Access database the records wouldnt be there yet, and therefore would need to be created using a SQL INSERT INTO statement.

 

[lothos12345]

Thank you.