MS Access connection made easy

  • 34 Views
  • Last Post 21 August 2019
admin@repcat.cat 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:

[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

alphonsa@intellibot.io 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.

Close