Connection to Encrypted Excel File.

I was using Ole db connection to connect the excel.Then Read the data & display on it on screen and then save it to database after validation.

But now excel is not getting connected via Ole db connection,as it is encrypted by some other program.

How to overcome on any encryption done on the excel data.

i am getting error as : External table is not in the expected format.

0 answers