Dear Friends,
please help me to resolve my problem wit Oledb connection.

For my current Project I need to fetch the data from an excel file.
Each second the data in the excel file is changing... What I want to do is, copy it from the excel and Validate it in every second.

So I use an Oledb connection to get the data from Excel file...
Its working excellent for two hours... After 2 hours I am getting an error that

"the connection for viewing your linked microsoft excel worksheet was lost......"

I searched a lot to get a solution but was futile.
I was stuck with this error for 3 days.. No Idea what would be the error ..

Please help me friends,

Is it possible to create a new connection once the current is lost? If so, catch the exection event, close the current and try a new connection.

Hope this helps.