Downloading question

lothos12345 · #1 09-12-2002, 06:34 PM

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** · #2 09-12-2002, 10:04 PM

What method are you using?

lothos12345 · #3 09-13-2002, 08:51 AM

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** · #4 09-13-2002, 08:03 PM

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

lothos12345 · #5 09-14-2002, 10:18 AM

Thank you.