Click here to Skip to main content
15,504,703 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
how to import Excel file in Asp.Net C# without using OLEDB.if Anyone knows Anything about releated to this Please answer...
Posted
Comments
CHill60 23-Apr-13 6:09am    
Well you could use Interop or ADO - why don't you want to use OLEDB?
StianSandberg 23-Apr-13 6:31am    
or ODBC?

1 solution

check this link out (I have posted my solution in there as well):
How to import excel data to SQL database table[^]
 
Share this answer
 
Comments
Murugesh0209 24-Apr-13 5:19am    
Actually my Requirement was to implement using Other than OLEDB. So because of that i choose interop. So please can you tell for Writing/Reading Excel file with using the Microsoft.Office.Interop.Excel Template.
I.explore.code 24-Apr-13 6:44am    
generally, MS Office won't be or shouldn't be installed on servers so my solution is independent of Interop. What if you deploy your website to a server that doesn't allow installing office? your functionality won't work. don't make your application dependent on things like interop.

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