Be.Smart ERP Picker
(EN) ERP Picker
(EN) ERP Picker
  • ℹī¸What is Be.Smart ERP Picker?
  • ⚙ī¸System Requirements
  • 🔑Installation & Activation Guide
  • 🆕What's New
    • Version 2.2.1.0
    • Version 2.1.3.0
  • Common information
    • Application configuration
      • Configuration file structure
      • Configuration file location
      • Configuration file parameters
        • Section [Settings]
        • Section [Mappings]
        • Section [MappingsC]
      • Examples of connections to data sources
        • Text file (txt | csv)
        • MS Excel
        • MS Access
        • MS SQL
        • Autodesk Vault
    • Overview of error messages
  • ERP Picker (Inventor add-on)
    • Basic description of functionality
    • Overview of commands
      • Be.Smart ERP Picker
        • Pick & Exit
        • Pick & Exit (Custom)
        • Export to file
        • Cancel
        • About
        • Help
        • Filtering and searching
        • Panel of additional information
      • Config
        • Edit config
        • Open folder
        • Exit
        • About
        • Help
      • About
  • ERP Picker (standalone app)
    • Basic description of functionality
    • Overview of commands
      • Export to file
      • Open folder
      • Cancel
      • About
      • Help
      • Filtering and Searching
      • Panel of additional information
Powered by GitBook
On this page
  1. Common information
  2. Application configuration
  3. Examples of connections to data sources

MS Access

PreviousMS ExcelNextMS SQL

Last updated 1 year ago

An example setup, including a downloadable source data file, for an MS Access database is shown below.

Settings ConnectionString

 ConnectionString=Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\Holixa ERP Picker Settings\accessData.accdb

Settings ConnectionSelectCommand

ConnectionSelectCommand=SELECT * FROM MATDBEN

Sample data file to download

1MB
accessData.accdb