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
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