0 votes
1 view
in RPA by (12.8k points)

I am accessing an excel file stored on a shared drive, for now, a couple of months without errors. All of a sudden, we have this issue popping out:  Cannot update. Database or object is read-only.

My original connection string looked like this:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="<FileName>";Extended Properties="Excel 12.0 Xml;HDR=Yes;".

I have tried the following one:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="<FileName>";Extended Properties="Excel 12.0 Xml;HDR=Yes;Readonly=0;"

and

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="<FileName>";Extended Properties="Excel 12.0 Xml;HDR=Yes;READONLY=FALSE;"

but nothing provides good results.

I need to connect to this excel workbook and get the data in order to perform some business-critical process, but nothing works so far as it always provides me with the mentioned error.

Any recommendation?

1 Answer

0 votes
by (29.8k points)
edited by

Hi, The reason behind the issue that you are facing can be the fact that you have headers with different datatypes, try using IMEX=1 at the end of the connection query and I think it'll work

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...