How to connect to a csv using database engine oledb

Learning Hub Academy Feedback
,
1

Hello guys ,
i use this in my databaseconnect ativity to connect to an excel “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”+ExcelFilePath+“;Extended Properties=”“Excel 12.0 Xml;HDR=YES”“”.
My question is how do i modify it for a csv …
Thanks a lot
Regards

2

Hello thanks guys …its okay now i used in my uipath.database.connect
“Provider=Microsoft.Jet.OLEDB.4.0; Data Source=”+in_FolderPath+“; Extended Properties=”“text;HDR=NO;FORMAT=Delimited”“”
where in_FolderPath is the path where my csv can be found.

Then i used in a query as string = “Select * from [”+in_FileNameWithExtension+"] "

Where in_FileNameWithExtension is the csv file name with extension. i.e filename.csv

I called the query in my execute query and ran. it worked

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.