Click here to Skip to main content
15,896,269 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello every one, Iam importing data from excel sheet to grid view. Getting this error. This is my code.

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:\ImportSheet.xlsx;Extended Properties=Excel 12.0");
OleDbCommand command = new OleDbCommand("SELECT * FROM [bapu$]", connection);
OleDbDataReader dr;

connection.Open();
dr = command.ExecuteReader(CommandBehavior.CloseConnection);

DataTable excelData = new DataTable("ExcelData");
excelData.Load(dr);
DataGrid1.DataSource = excelData;
DataGrid1.DataBind();

Error: Could not find installable ISAM.What should be the problem. Please suggest me.
Posted
Updated 1-Feb-13 17:05pm
v2

1 solution

You may want to take a look at this: http://support.microsoft.com/kb/209805[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900