Pallavivalunj
New Member
Hii,
I m working with excel which has data around 80k to 1L per sheet.
While taking the data in collection i get error of memory exception.
What i wanna to do is to send the excel sheet data to sql table(tables are already created). And the call procedures which are also done.
How can i transfer the data direct from excel to sql is there any option.
Or else how can i come over the situation im facing right now.
Please help me to get solution.
Thanka in advance...
I m working with excel which has data around 80k to 1L per sheet.
While taking the data in collection i get error of memory exception.
What i wanna to do is to send the excel sheet data to sql table(tables are already created). And the call procedures which are also done.
How can i transfer the data direct from excel to sql is there any option.
Or else how can i come over the situation im facing right now.
Please help me to get solution.
Thanka in advance...