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,