MS Access connection made easy

  • Last Post 21 August 2019
RepCat posted this 20 August 2019

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:

; 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 posted this 21 August 2019

Hi Winter,

Thank you for the suggestion

If you need any assistance while learning Intellibot, please contact us.

Thanks & Regards,

Alphonsa Kalapala.