Reading Excel file when it is opened by excel application

Newbie Member
7Jun2006,23:03   #1
milinddhande's Avatar
Hi all,

please tell me how read excel file from .net when it is already
opened by another user using microsoft excel application.
i tried following

1] Using oledb
when file is closed i can read but when it is kept open i cannot
2] excel object
same as above

thanks in advance
Newbie Member
9Oct2006,03:36   #2
<Z3N>'s Avatar
Hi are you using recordsets? If so what is the locktype set to ?