ODBC and Excel (2 replies)

Posted on .NET 247 See other posts from .NET 247
Published on 03 Dec 2009 22:12:04 Indexed on 2010/03/07 23:55 UTC
Read the original article Hit count: 592

Filed under:
Hello, I am using the following connection to Query and Excel Spreadsheet: AConnectionString "Driver {Microsoft Excel Driver (*.xls)};DriverId 790;Dbq " & ofdSelectFile.FileName & ";DefaultDir c:\;" ASourceConnection New Odbc.OdbcConnection(AConnectionString) Dim ADataAdapter as new odbc.odbcDataAdapter("SELECT * FROM $Sheet1", ASourceConnection) ADataAdapter.Fill(MyDataset) This works Great, howe...

© .NET 247 or respective owner