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/08
3:32 UTC
Read the original article
Hit count: 665
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
