» 
Excel Spreadsheet
Hello.
Does anyone know how to read-in an excel spreadsheet using a data-adapater?
I need to read-in this .xls file, assign it to a dataset and supply relations to ultimately create the table of data I need.
I have tried using an ODBC connection and an ODBC data adapter unsuccessfully so far, and MSDN has nothing on excel spreadsheets.
I am working in VB.net with a windows form-based project.
Any assistance will be most appreciated.
Thank you,
A. Teixeira
|