I’m trying to connect to a folder called “csvs” with a database connection string. The folder will contain a .csv file for each table in the database.
Connection string:
“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=csvs;Mode=ReadWrite;Extended Properties=‘text;HDR=Yes;FMT=Delimited;ReadOnly=False’;”
Provider name:
“System.Data.OleDb”
Query:
“CREATE TABLE table_name (column1 varchar(255), column2 int)”
UiPath throws an exception:
“Execute query : Cannot modify the design of table ‘table_name’. It is in a read-only database.”
when trying to run the query.
I don’t have much experience with connection strings and I’ve been unable to figure out why my connection string seems to be connecting in read only mode. I haven’t found a solution on google either
Any help would be greatly appreciated, Thanks!