By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,795 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,795 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
http://www.codeproject.com/dotnet/ExportExcelData.asp

http://www.dotnet247.com/247referenc...37/186640.aspx
"sa*@spp.net" <sa*@spp.net> wrote in message
news:AI*****************@bignews5.bellsouth.net:
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


Nov 21 '05 #2

P: n/a
On Tue, 19 Oct 2004 18:06:24 GMT, <sa*@spp.net> wrote:

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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.