Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi,
 
i need to read files from shared server and then store it in DB.
The file size may vary and can be in 50mb - 50 mb.
 
i need to read the files-- excel,access (both .mdb and .acccdb) and .csv from the server.
 
I'm confused whether to go for Interop Dll's or Oledb connection.
I need to read these files line by line.
My application : Windows Service and a asp.net web application.
 
Windows service : for full processing.
Web application : For reading the header row of the file (its for some UI validation to be shown to user).
 

Please tell me what will be the pros and cons of choosing one of these options on other.
Please also tell me what all server side setup i require for reading these files.
like for reading through interop do i need MS office installed at server side.
and is ace engine 12.0 is by default present in server??
 
Any help is appreciated.
 
Thanks.
Posted 18-Feb-12 11:26am
snair88465
Edited 21-Feb-12 7:39am
v2

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



Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100