Click here to Skip to main content
12,820,894 members (31,662 online)
Rate this:
Please Sign up or sign in to vote.

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 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.

Posted 18-Feb-12 12:26pm
Updated 21-Feb-12 8:39am

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170308.1 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2017
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