Microsoft Access
Microsoft Access
When creating new database connection, specify the database path to the .mdb or .accdb file in database name field.
This database connection uses the UCanAccess driver which works well for reading with TableInput, DatabaseLookup, but it’s not great for writing. For writing it is better to use the Microsoft Access Output transformation.
Option
Info
Type
Relational
Driver
Included
Version Included
5.1.3
Hop Dependencies
None
Documentation
JDBC Url
jdbc:ucanaccess://path.mdb
Driver folder
<Hop Installation>/lib/jdbc
Last updated