Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProStructures
  • Product Communities
ProStructures
ProStructures Wiki Importing i-Model metadata into MS Access
    • Sign In
    • -ProStructures
      • +ProStructures - What's New
      • +ProStructures For Beginners
      • -ProStructures CONNECT Edition
        • +Installation - ProStructures CONNECT Edition
        • +MicroStation CONNECT Edition Basics - ProStructures CONNECT Edition
        • +General - ProStructures CONNECT Edition
        • +Setup & Customization - ProStructures CONNECT Edition
        • +Template Manager - ProStructures CONNECT Edition
        • +Navigation & Display Commands - ProStructures CONNECT Edition
        • +Administrate Groups command - ProStructures CONNECT Edition
        • +Global Settings/Options - ProStructures CONNECT Edition
        • +Key-in Commands - ProStructures CONNECT Edition
        • -Import/Export - ProStructures CONNECT Edition
          • +ISM (Integrated Structural Model) - Import/Export
          • +IFC (Industry Foundation Classes) - Import/Export
          • +DWG - Import/Export
          • +ProStructures-Navisworks - Import/Export
          • Importing i-Model metadata into an Excel sheet
          • Importing i-Model metadata into MS Access
          • Workaround for MS Access error “… is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long”
          • i.dgn model created via ProStructures CONNECT Edition get crash in Navigator V8i, while doing Clash check
          • Error : ISM engine failed
          • How to print 3D PDF in ProStructures CONNECT Edition?
          • How to print 3D PDF which includes the element properties in it?
          • Upgradation of multiple ProStructures DGN files from the lower version to the higher version.
          • How to open/view the ProStructures' file in Tekla structures
          • How to export the STEP file from the ProStructures CONNECT Edition
        • +ProStructures CONNECT Edition FAQ
        • API / SDK ProStructures Connect Edition
      • +ProStructures V8i SELECTSeries
      • +ProjectWise Integration - ProStructures
      • +Object Enablers – ProStructures/ProSteel
      • Working from home with ProStructures
      • ProStructures Platform Version on Release Updates
      • ProStructures Version Support
    • +ProSteel
    • +ProConcrete
    • +ProStructures Licensing
    • +ProStructures Customer Examples / Projects

     
     Questions about this article, topic, or product? Click here. 

    Importing i-Model metadata into MS Access

      Product(s): ProSteel
      Version(s): CONNECT Edition (10.XX.00.XX)
      Environment: N/A
      Area: Interoperability
      Subarea: N/A
      Original Author: Vyanktesh Nama, Bentley Product Advantage Group

    Overview

    In this wiki, we are going to learn how to import *.iModel metadata into MS Access via i-Model ODBC.

    Method

    Please follow the below steps to get metadata of *.iModel into MS Access:

    Prerequisite: You need to have installed “iModel ODBC Driver 64-bit” in your system. To download this Click Here.

    a. Open ProStructures model of which you want to get metadata into MS Access. (for e.g. see below image).

    b. Go to Backstage > File and click on “Publish i-model”.

    c. After clicking on that “Publish i-model(s)” dialog box will open. Please follow the steps as shown in below image.

    1. Check the box for “Create a single package”.

    2. Here you can set the default path to save all iModels.

    3. Check the box for “Create an iModel version”.

    4. Select the 1.6 version for iModel.

    5. Finally click on “Publish” button to publish iModels.

    d. Wait for few seconds to complete the process. After process is completed go to default path, here you can find *.imodel is get published.

    e. Now, search “odbc data sources (64-bit)” in the windows start button and click on it to launch.

    f. In ODBC Data Source Administrator (64-bit) dialog box, 

    1. Go to System DSN tab.

    2. Double click on iModel 1.6 Data Source. iModel ODBC DSN Configuration dialog box will open.

    3. Click on Browse button to browse recently published *.iModel.

    4. Now, here select the iModel and

    5. Click on open button.

    6. Click on OK button of iModel ODBC DSN Configuration dialog box.

    7. Click on OK button of ODBC Data Source Administrator (64-bit) dialog box.

    g. Launch MS Access, go to External Data > New Data Source > From Other Sources and click on ODBC Databace.

    h. Select first option and then click on OK button.

    i. In Machine Data Source tab select iModel 1.6 Data Source and then click on OK button.

    j. Here you can select multiple tables at a time. In this case, we have Selected All.

    k. In the below image you can see all the data get imported into MS Access.

     

    In this way, we can import the *.iModel metadata into MS Access via i-Model ODBC.

    • ProStructures
    • Publish i-model
    • ODBC Databace
    • iModel 1.6 Data Source
    • imodel
    • ProStructures CONNECT Edition
    • odbc data sources
    • Access
    • MS Access
    • i-Model ODBC
    • iModel ODBC Driver 64-bit
    • Share
    • History
    • More
    • Cancel
    • Vyanktesh Nama Created by Bentley Colleague Vyanktesh Nama
    • When: Wed, Dec 28 2022 8:41 AM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies