Question connect to Excel?

[Devendra Singh Rautela]

Sir,
I need help to connect my vb dotnet 2005 project to microsoft excel 2003 database file through data source wizard. Please show whole method with examples.Thanks.

 

[jmcilhinney]

In the wizard, select Database
Click New Connection
Click Change on Data Source
Select <other>
Select OLE DB provider
Select Jet 4.0 as OLE DB provider
Click Advanced and enter connection string properties, which you can get from ConnectionStrings.com