provider used for msexcel

[srivalli]

i want to use backend as msexcel.

so i am very confused abt the connection path.

its very urgent

 

[ayozzhero]

You mean something like this:

 Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
            & "Data Source=C:\ExcelData.xls" _
            & ";" & "Extended Properties=Excel 8.0;"

Personally, I think querying an excel file is difficult. But if you insist, better look at:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q311731
http://www.developerfusion.co.uk/show/4682/1/

 

[kulrom]

I think this is already answered ... http://www.vbdotnetforums.com/showthread.php?t=3713

Cheers

 

[srivalli]

Displaying error as

yaa i know it
i tried ur way but even then it is displaying error as
"Cannot find installable ISAM"
i am unable to understand the error first
can u let me know
thanks

I think this is already answered ... http://www.vbdotnetforums.com/showthread.php?t=3713

Cheers