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.