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.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

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