Click here to Skip to main content
11,411,494 members (65,711 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 12:26pm
Edited 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
0 OriginalGriff 213
1 Sergey Alexandrovich Kryukov 195
2 Sascha Lefévre 120
3 ProgramFOX 90
4 Dave Kreskowiak 90
0 Sergey Alexandrovich Kryukov 8,920
1 OriginalGriff 7,128
2 Maciej Los 3,440
3 Abhinav S 3,248
4 Peter Leow 3,059

Advertise | Privacy | Mobile
Web01 | 2.8.150414.5 | 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