I am using Visual Studio 2005 (VB) and have an application which uses MS Access database to hold customer details. I would like to add a function to my app which imports data from Excel spreadsheet. The dataset already contains data, so the excel data should be appended.
How can I fill my dataset with the data from the spreadsheet? I assume this is the best way to get the data into the .mdb