How to create a connection to Excel

hog

Well-known member
Joined
Mar 17, 2003
Messages
984
Location
UK
If I use this connection string in code:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\returns.XLS;Extended Properties=Excel 8.0;

I can connect to the .xls file.

How do I create this connection using server explorer? Each time I try using this I get all sorts of error:(
 
Back
Top