How to resolve error while connecting to CSV file from Studio Connect activity using ODBC connection?
Resolution
The connection string needs to be defined to use database activity. The connection string contains how to connect to the database from the engine side.
If the use of String.Format is unfamiliar, the {0} will be swapped with the second argument which is databaseFileDirectory. The key is this value specified for databaseFileDirectory is not the file itself, but the folder where file of interest is stored.
String.Format(“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=”"{0}""; Extended Properties="“text;HDR=NO;FORMAT=Delimited”"",databaseFileDirectory)
The file of interest is specified at query time.
String.Format(“SELECT * FROM [{0}]”,“test.csv”)
Please refer to the sample in the UiPath forum: https://forum.uipath.com/t/working-with-csv-with-database-activities/322973.