Import / Export Excel Spreadsheets into and from datasets using Visual Studio 2008 VB9
Posted on 2008-10-03
I have a VB9 / Visual Studio 2008 application, which uses a .mdb database. I select data from the database with a select button using an sql statement so that it shows only selected data in the grid on screen. I then have the option to print just that selected data. I now need to add the option to export just the selected data to an excel spreadsheet. Similarly, I also need the option to import from the same spreadsheet that was previously created by the above process, into that selected dataset, so that it only updates the records present in the selection.
I have no idea how to do this in Visual Studio VB, and need the easiest, shortest method to do this.