Access (ODBC) Connector

Access (ODBC) Connector




Access



To access Access, I had to download the Microsoft Access Database Engine 2010 Redistributable, https://www.microsoft.com/en-us/download/details.aspx?id=13255.

Once installed, open the ODBC tab on your Origin or Destination tab and click Data Source Administrator. Most computers will have several Access data sources available. The newly installed data source is "Microsoft Access Driver (*.mdb, *.accdb)". Once selected, everything else is standard Starfish.


Parameter
Description
Connection String

ODBC Connection Edit Screen


    • Related Articles

    • Hubspot Connector

      Additional Documentation This Connector is based on the Hubspot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DHG/ado/ Hubspot Connector Note: As of September 8, 2020 ...
    • CSV Connector

      Additional Documentation This Connector is based on the CSV ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RVG/ado/ CSV Via Upload (in Cloud Cartographer) When you upload ...
    • Act! Connector

      ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: StarfishETL does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium (v18+) using ...
    • MySQL Connector

      MySQL Origin Note that the connection string must match the sample connection string shown in StarfishETL: server=<server_name>;uid={0};pwd={1};database=<db_name>; The string components must be placed in that order. {0} is a variable that refers to ...
    • Excel Connector

      Additional Documentation This Connector is based on the Excel ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RXG/ado/ Establishing a Connection Connecting to Excel Data ...