Dear All,

I have a ASPX page. It will read data from an Excel file and bind into DataGrid but I have problem:

File source:

Private sub BindGrid()
   Dim strSQL As String
   Dim strConn As String

   'Connection String
   strConn = "Provider=Microsoft.Jet.OleDb.4.0; " & _
             "Data Source=C:\Data.xls; " & _
             "Extended Properties=Excel 8.0;"

   'Declare and initialize connection object
   Dim objConn As New OleDb.OleDb.Connection(strConn)

   strSQL = "SELECT * FROM [Data$]"
   'Data is name of sheet in Excel file

   'Declare and Initialize OledbCommand object
   Dim objCommand As New OleDb.OleDbCommand(strSQL, objConn)

   'Open connection
    objConn.Open()

    'dgData is name of DataGrid
    Me.dgData.DataSource = objCommand ExecuteReader(CommandBehavior.CloseConnection)

    Me.dgData.DataBind()
End Sub

But I received this ERROR:


Exception Details: System.Data.OleDb.OleDbException: Unspecified error

Source Error:

Line 77: Dim objConn As New OleDbConnection(strConn)
Line 78: Dim strSQL As String = "Select * FROM [Data$]"
Line 79: objConn.Open()
Line 80:
Line 81: Dim objCmd As New OleDbCommand(strSQL, objConn)

Source File: E:\Inetpub\wwwroot\GUIVP\Admin\ImportData.aspx.vb Line: 79

Stack Trace:

[OleDbException (0x80004005): Unspecified error]
   System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
   System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
   System.Data.OleDb.OleDbConnection.Open() +203
   GUIVP.ImportData.BindData() in E:\Inetpub\wwwroot\GUIVP\Admin\ImportData.aspx.vb: 79
   GUIVP.ImportData.Page_Load(Object sender, EventArgs e) in E:\Inetpub\wwwroot\GUIVP\Admin\ImportData.aspx.vb: 48
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750



Please help me!
Thank you so much.

L.V.L

__________________
L.V.L

In the excel document on the bottom left corner their are tabs that name each datasheet, is the name of the sheet actually Data or is it Sheet1? The default given by excel Sheet1. If it is Sheet1, rename the sheet to Data.

Thank you very much

I found cause of problem!

User permission !



L.V.L

evevn i am getting the same error. can u help me please

Pranav Shah

try this patch http://support.microsoft.com/kb/827190