Reading Excel file when it is opened by excel application

milinddhande's Avatar, Join Date: Jun 2006
Newbie Member
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
<Z3N>'s Avatar
Newbie Member
Hi are you using recordsets? If so what is the locktype set to ?