Microsoft Access

[lothos12345]

I need a quick jump start regarding the code necessary to connect to a Access database and loop through records recording them in an array and having the information in the array printed to an excel file. Any help regarding the proper code on how to accomplish this task is greatly appreciated. And of course using the programming language Visual Basic.NET.

 

[Derek Stone]

http://www.computerhelp.forum/showthread.php?s=&threadid=49577

I already supplied to you, months back, code that reads/writes to cells in Excel. All you need to do is put these two examples together.

 

[lothos12345]

Yes this is true however I am need to understand how to loop through data. For example reading multiple columns and rows in excel and inserting them into an Access table. I thank you for the code that you gave me, however using that code I can only read 1 cell in excel and send it to Access. Try as I might to get it in a loop I am not able to accomplish this task. I want to be able to read multiple columns and rows of data in excel until I hit the word "end" which will be in column 1 and send it to an Access table. Any help that you can give me with this is greatly appreciated.