Hi, I thought I would share this in case it makes anyone's life easier.
Problem: connect to an MS Access database via OLEDB.
1) Create a text file somewhere called "jet.udl". You will see the icon change when you save it.
2) Double click on it.
Here are some representative screenshots:
Once you have all the information in, you might be wondering what to do with that "jet.udl" file. Just open it with a text editor, and you should see something like this:
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.ACE.OLEDB.16.0;Data Source=%UserProfile%\Documents\My Data Sources\Loan4Access.accdb;Persist Security Info=False
All you need is the last line, it turns out. Add an SQL activity to your bot:
You can see I've just pasted in the connection string.
Here's some tongue-in-cheek sample SQL for the query (just double click on the title bar of the activity where it says 'SQL':
For testing, right-click on the activity and select "Run From Here".
If all is well, you can right-click on the data port of the activity to preview your data.
Best regards,
Winter