C# Import xls file into sql server

[upadhyayanuj]

Hi can anybody tell what is error in following code, its running through .Net 2005 editor fine,
but when running on browser gives error:
No error message available, result code: E_FAIL(0x80004005).

 try
        {
            // Create Connection to Excel Workbook
 
            OleDbConnection connection = new OleDbConnection(excelConnectionString);
 
            if (connection.State == ConnectionState.Closed)
            {
 
                connection.Open();
                     }
 
            OleDbCommand command = new OleDbCommand("select Name,Age,City,Phone FROM [Data$]", connection);
 
            // Create DbDataReader to Data Worksheet
 
            OleDbDataReader dr = command.ExecuteReader();
 
                     // SQL Server Connection String
            string sqlConnectionString = "Data Source=localhost;database=demo;user id=sa;pwd=sa";
 
            // Bulk Copy to SQL Server
 
            SqlBulkCopy bulkcopy = new SqlBulkCopy(sqlConnectionString);
 
                     bulkcopy.DestinationTableName = "ExcelData";
 
            //            bulkCopy.WriteToServer(dr);
            bulkcopy.WriteToServer(dr);
            bulkcopy.Close();
            if (!dr.IsClosed)
                dr.Close();
 
   Response.Write("Data Imported From Xls file");
            if (connection.State == ConnectionState.Open)
                connection.Close();
        }
 
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }

[Frinavale]

I think it might have something to do with your connection string.

See this article. It could really help you out.

[upadhyayanuj]

I think it might have something to do with your connection string.

See this article. It could really help you out.

Thanks Frinavale,

It works,
I had not put the file in my application folder,
I had just put the file in my application folder and its worked

Thanks for help

[divyavk21]

I'm currently struggling to upload the Excel sheet data to the SQL Server using .Net. Please help me in provide the source code for it. I'll be very thnakful for the timely help.

Thanks Frinavale,

It works,
I had not put the file in my application folder,
I had just put the file in my application folder and its worked

Thanks for help

[Frinavale]

I'm currently struggling to upload the Excel sheet data to the SQL Server using .Net. Please help me in provide the source code for it. I'll be very thnakful for the timely help.

This forum is dedicated to helping you understand your problems so that you can create your own solution. Please attempt to solve the problem before asking for help with it so that we can address any difficulties you face.

What have you tried so far?
What problems have you encountered?

Please post any code that you think might be causing the problem (remember to use code tags when posting code snippets)

-Frinny