Last post Jan 31, 2011 04:40 PM by dcwmorley
Jan 20, 2011 02:17 AM|erkapilbhatia|LINK
I want to import an excel file in .net. Excel file resides on server. when I try to imort the file using below code , i am getting error.
' Connect to the Excel Spreadsheet
'Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
' "Data Source=C:\Users\tcs0028\Desktop\Upload.xls;" & _
' "Extended Properties=Excel 8.0;"
"Extended Properties=Excel 8.0;"
' create your excel connection object using the connection string
If i import excel file from local drive its working
fine. But when i try to import excel file from server(URL of file) then i am getting error.
I am getting error(Oledbexception Failure creating
file.). Please sugget how to import excel file that in resides on server(file is not on my local drive, i will access file through URL).
vb .NET 2.0
Excel Import Asp.net
Jan 20, 2011 03:59 AM|stanly|LINK
Jan 31, 2011 04:40 PM|dcwmorley|LINK
I had a lot of problems getting data from an Excel file, but I managed to draw some of the teeth. You can find a fully worked example, with indications of what can go wrong, at www.3bbb3.co.uk