I have one excel file with more than 10 lacks records,
I am using Ado dot net for read this excel (Microsoft.ACE.OLEDB.12.0)
when i am reading this file through C# then i am getting(or reading) only 24 thousand rows (for Bulk Insert)
when I am hosting this on my
local system (IIS 6)(by using "Localhost") ,I am able to read all rows(10 lacks rows)
if i am hosting the same on my
main server (IIS 7), then i am able to read only 24 thousand rows only
When I CONVERTED EXCEL TO CSV THEN AGAIN CSV to EXCEL after i tryied to upload then I can read 31 thousand rows(
no of row increased)
Could any one please help me to solve this problem
1 My connection string for reading excel is
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0;HDR=YES; IMEX=0;\"";
2
OleDbCommand xlCmd = new OleDbCommand("SELECT * FROM [" + sheetName + "]", xlCon);
xlCmd.CommandType = CommandType.Text;
OleDbDataReader xlReader = xlCmd.ExecuteReader();
3 my time out more than 6000
[EDIT]CODE tags added - LOSMAC[/EDIT]