Reading excel for size 7MB

Question

hello ppl,

i have a problem. i need to upload excel files into sql database, my application is working fine when i run it on my local machine, but the issue is when i deploy it on my IIS or any other server, and when iam trying to read the excel that has 150000 records my application reads only 20000 records. and doesnt throw any error.

can you please help me out

Answer 1

Hello Rakesh:

Try checking the options on your server for any limits.  20,000 sounds like a parameter that may be set in the server software.  As a test, create an Excel file with 20,100 records and see if it still only reads 20,000.  If that's the case, notify your Server administrator.

Regards,

---

Rich Locus, Logicwurks, LLC

http://www.logicwurks.com

Answer 2

What is the code you are using to move the data to SQL Server?

---

Bob Larson, Access MVP 2008, 2009, 2011

Answer 3

Do you need that much of data together.

I think you shoudl better go for any database softaware and take help of ADO or ADO.net for connecting from Local source.

I know it may not help you but just as future suggestion.

---------------------------------------------------------------------------------------------

Please do not forget to click “Vote as Helpful” if any post helps you and Mark as Answer if it solves the issue.

Answer 4

hello pl,

i found the solution, my problem is with the connection string

 

string connctionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended Properties=\"Excel 12.0;HDR=" + HDR + ";IMEX=0\""

, filename);

i changed the connection string IMEX = 0 TO IMEX = 1