Would you please kindly explain in detail how to use the "Database: Connect" action to access a .csv file on the runner's desktop?
I have read through this prior APeople question, but the actual connection string syntax is not explained.
Questions I have include:
- Do I have to install additional software on the runner in order to access a .csv like a database? I would like to avoid adding more software onto the runner.
- Are there a variety of connection string formats I could use?
- Is one preferable over the other?
- What does each part of the connection string mean? How can I apply this to my specific case (I have a desktop path to a .csv - I need to connect to it)
I already have extensive knowledge of SQL and am very comfortable performing SELECT statements on data, but I am a complete novice at actually establishing the connection.
We are using Windows 10 and, as far as I know, we just have the basic standard drivers installed.