You have to download it and install within MS Access. There is a 3-minute video on the website explaining the installation process. The software costs $500 as a one time fee.
The software creates an ODBC connection with Quickbase - any app that shares a common apptoken used in the qunect installation. You link a Quickbase into your MS Access database the same way you would any external table. At this point, your Quickbase data is viewable in Access like a regular Access table.
To push data, you write an append query in MS Access - that uses your text files as the source and Quickbase table as the destination.
The other big benefit is in troubleshooting- when a connected table starts to fail, you don�t have many options for converting to a regular table. This qunect setup gives tremendous flexibility.
Use case: On a daily basis, I refresh our backlog info from our ERP this way. First I call API_PurgeRecords, then I call my Access append query
