[en] Microsoft Access - Alteryx Driver
[en] Alteryx supports the Microsoft 2013, 2016 and 365 runtimes for reading from and writing to .accdb files.
[en] Configuration
[en] The File Format Options in the Output Data Tool available for Microsoft Access (.accdb) files provide the following functionality:
[en] Append Existing
[en] Delete Data & Append
[en] Overwrite Table (drop)
[en] Create New Table
[en] Known Issues
[en] Loading table names and refreshing data in the Input tool for 32bit Access files produces an error. See Community article for more information.
[en] The Visual Query Builder will not load for Access runtime 2016 and 365.
[en] Alteryx cannot write to DateTimeExtended fields.