Click here to Skip to main content
11,804,008 members (76,797 online)
Rate this: bad
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 11:26am
Edited 21-Feb-12 7:39am

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

  Print Answers RSS
0 OriginalGriff 3,140
1 Maciej Los 1,910
2 KrunalRohit 1,907
3 CPallini 1,845
4 Richard MacCutchan 1,187

Advertise | Privacy | Mobile
Web04 | 2.8.151002.1 | Last Updated 21 Feb 2012
Copyright © CodeProject, 1999-2015
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