lothos12345 Posted September 12, 2002 Posted September 12, 2002 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. Quote
Moderators Robby Posted September 13, 2002 Moderators Posted September 13, 2002 What method are you using? Quote Visit...Bassic Software
lothos12345 Posted September 13, 2002 Author Posted September 13, 2002 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. Quote
*Gurus* Derek Stone Posted September 14, 2002 *Gurus* Posted September 14, 2002 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. Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.