How to solve error “Cannot update. Database or thing is read-only.” Excel Database Automation Anywhere

I to be accessing one excel record stored on a mutual drive, for now, a pair of months without errors. Every one of a sudden, we have actually this worry popping out: can not update. Database or object is read-only.

You are watching: Cannot update.database or object is read only

My original connection string looked choose this:

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

I have actually tried the adhering to one:

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


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

but naught provides great results.

I require to attach to this excel workbook and also get the data in bespeak to execute some business-critical process, but nothing works so much as it always provides me with the mentioned error.

Any recommendation?

Please log in in or it is registered to add a comment.

Please log in or it is registered to prize this question.

See more: D&Amp;D Tomb Of Annihilation Dice, Vitamin D Deficiency

1 Answer

0 votes
answeredJul 12, 2019by Prakhar_04(29.8k points)editedJul 12, 2019by Prakhar_04

Hi, The reason behind the concern that you are dealing with can it is in the fact that you have headers with different datatypes, shot using IMEX=1 at the finish of the connection query and also I think it"ll work

Please log in in or it is registered to add a comment.

Related questions

0 votes
1 answer
How to compare 2 Excel Workbooks without utilizing Macros or VBA in Automation Anywhere?(Only using the commands that are easily accessible in AA)
askedJul 10, 2019in RPAby boy name kapoor(5.3k points)
0 votes
1 answer
Unable to use Excel as Database in Automation all over 10
askedJul 11, 2019in RPAby Abhishek_31(12.8k points)
0 votes
1 answer
pdf table come excel in Automation anywhere
askedJul 17, 2019in RPAby Abhishek_31(12.8k points)
0 votes
1 answer
Unable to open up excel spreadsheet in automation anywhere
askedJul 11, 2019in RPAby Abhishek_31(12.8k points)
0 votes
1 answer
Automation all over Enterprise because that Loop in excel file
askedJan 23, 2020in RPAby Abhishek_31(12.8k points)
Welcome to Community. Acquire your technological queries reply by top developers!

28.4k questions

29.7k answers


94.4k users

Popular Questions
Browse Categories

Post Graduate Programs

Certification in Digital Marketing |Certification in big Data analysis |Certification in Cloud & Devops |Certification in complete Stack net Development

Popular understand Courses

Big Data and also Data scientific research Master’s food |Data science Architect Master’s regimen |Cloud and DevOps Architect Master’s course |Artificial intelligence Engineer Master’s course |Microsoft Azure Certification Master’s Training

Popular Courses

Data scientific research Course online |Big Data Hadoop Certification cultivate |Machine discovering Course digital |Artificial knowledge Course and also Training |Salesforce Certification Training: Administrator and also App Builder |Tableau Training and also Certification course |Python Data scientific research Course & training |Ethical Hacking food |Business Analyst course |Courses in Cyber Security