import excel to sql

have you restarted your system and check? 

Regards,
Iftikar

Hi Amitesh,

The appropriate user account (NETWORK SERVICE by default) needs MODIFY permissions on the folder that the Excel file sits in.

Right Click on the folder where your Excel file lies.
Goto Security > Edit >Add.

Find and Add NETWORK_SERVICE account. Click OK. Assign all the permissions to this account and try to run your application.

Feedback awaited.

Hope it helps.

Did you changed the sheet name and check .....

which browser you are using...

yes it working perfectly after changing the Exel07 to sheet1

in your code i checked that you are providing the exel file name. but it actually required the Sheet name



check this line of code


  OleDbCommand cmd = new OleDbCommand("Select [CustomerID],[City],[Country],[PostalCode] from [Sheet1$]", excelConnection);


modify your code and reply.



if it help you mark it as answered.

attach your code. i will check

hi,

i checked your code and modified. just check the attached file and run it.

1st open the .mdf file.
2nd match the table column name with exel column name.

can you just restart your system and check again?

Regards,
Iftikar

String strConnection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
//file upload path
string path = fileuploadExcel.PostedFile.FileName;
//Create connection string to Excel work book
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;Persist Security Info=False";
//Create Connection to Excel work book
OleDbConnection excelConnection =new OleDbConnection(excelConnectionString);
//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand("Select [CustomerID],[City],[Country],[PostalCode] from [Excel07$]",excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);
//Give your Destination table name
sqlBulk.DestinationTableName = "excelimport";
sqlBulk.WriteToServer(dReader); excelConnection.Close();


in this code..its showing..
The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data. ..


but this code doesnot have anyfolder to upload excel file in it...

hi,

refer to this link and follow these steps

http://www.aspdotnet-suresh.com/2013/01/c-microsoft-office-access-database.html


reply

what is the error?

Regards,
Iftikar

hi,

i modified your code just check the attachment.

there is some error sir

i have modified your code behind, try like this


Regards,
Iftikar

what compilation error you are getting? can you share it?

Regards,
Iftikar

hi refer to this link

http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html

Hi,
        Please refer this link

http://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html

Regards,
Iftikar