Opening Excel and downloading into Access using .NET

[lothos12345]

I am developing a program that I want to open an excel file take that information and insert it into the proper fields in an Access 2000 database. My main problem is figuring out how to open a Existing excel file using Visual Basic.NET. Any help with the correct programming syntax on how to accomplish this task would be greatly appreciated.

 

[Derek Stone]

If youre using Visual Studio its a simple matter of adding a reference to the Excel Application library. Right click on your project in the Solutions Explorer window and hit References. The code will be fairly similar to its Visual Basic 6 equivalent.

 

[lothos12345]

I was unfamiliar with the Visual Basic counter part of how to accomplish this. A quick sample of how to do this would be greatly appreciated.