How does one connect to local excel file using data wizard is it possible vb.net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greets,

How does one connect to a local excel file using data wizard is it possible?

I'm trying to connect to an excel file and populate a dataset and combo box with the data from excel

TIA
 
¤ Greets,
¤
¤ How does one connect to a local excel file using data wizard is it possible?
¤
¤ I'm trying to connect to an excel file and populate a dataset and combo box with the data from excel

Unfortunately you can't use the Jet OLEDB Provider with Excel when using the DataLink Properties
dialog. The alternative is to create an Excel ODBC DSN and use the OLEDB for ODBC Provider to add
the connection to Server Explorer, or, create your Connection objects in code instead.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top