Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki To Import Access Specification Reports in Excel
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • -OpenPlant Modeler v8i
          • +Component - OpenPlant Modeler
          • +Drawing Generation- OpenPlant Modeler
          • +Errors, Logs, Messages, Crashes - OpenPlant Modeler
          • +Import/Export- OpenPlant Modeler
          • +Installation - OpenPlant Modeler
          • OpenPlant HVAC-OpenPlant Modeler
          • OpenPlant Modeler [FAQ]
          • -OpenPlant Specification Generator
            • Error in Spec Gen does not load EC Class Name when Catalog is loaded
            • Field Reference Description in OpenPlant Modeler
            • Gaskets Not Converted from PSDS Spec to OpenPlant Modeler Spec
            • How to Convert AutoPLANT PDW Catalog to OpenPlant Modeler Format Using Exchange Option of SpecGen
            • How to Convert PSDS Catalog/Spec to OpenPlant Format
            • How to Correct Spec Changes Using Spec Validation Tool
            • How to Create New Spec in OpenPlant Specification Generator
            • How to Delete-Modify Sections in Specification Generator
            • How To Filter data with Multiple Selection in Specification Generator
            • How to Fix Unit Conversion Issue in OpenPlant Specification Generator
            • How to Include Branch Code Inside Branch Table For Specification Generator in OpenPlant Modeler
            • How to Modify Static Text of Custom Description in OpenPlant Specification Generator
            • +How to Use AutoPlant Catalogs to Create OpenPlant Spec using SpecGen
            • Lap Joint Stub End Not Converted from PSDS Spec to OpenPlant Modeler Spec
            • Olet Section Doesn't Show All Sizes From Catalog in Specification Generator
            • OpenPlant End Condition Long Descriptions
            • To Add Custom Description in a Field to Populate in OpenPlant Modeler
            • To Add EC_CLASS_NAME for Component Table in Catalog Editor
            • To Add LookUp Value in Spec Grid during Placement of Component in OpenPlant Modeler
            • To Add Support Class Property to be Read by Specification in OpenPlant Modeler
            • To Convert Nozzle Data from PSDS to OpenPlant Modeler Spec
            • To Create Missing FLOW_METER Class data in OpenPlant Modeler
            • To Create Missing SIGHT_GLASS Class data in OpenPlant Modeler
            • To Define Default Value of Branch Code for Piping Component
            • To Fix Multiple Duplicate Records Showing in Catalog Editor Interface
            • To Import Access Specification Reports in Excel
            • To Modify Default Outside Diameter Value for End Types in OpenPlant Modeler
            • To Pick Reduced Half Coupling under Branch Table Automatically in OpenPlant Modeler
            • Use Of Reinforced Branch Connection Types Using Branch Table
          • +ProjectWise - OpenPlant Modeler
          • +Properties - OpenPlant Modeler
          • +Release Notes - OpenPlant Modeler
          • +Schema - OpenPlant Modeler
          • +Settings/Attributes - OpenPlant Modeler
          • +Structural Modeling Components (SMC)- OpenPlant Modeler
          • +Tasks - OpenPlant Modeler
          • +Training - OpenPlant Modeler
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
        • How to find iModel.dgn file of another domain in PlantSight
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

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

    To Import Access Specification Reports in Excel

    Applies To 
    Product(s): Specification Generator
    Version(s): 10.00.00.119
    Environment:  Windows 10 (64 bit)
    Area:  Specification Generator
    Subarea:  Import/Export
    Original Author: Nikhil Salunkhe, Bentley Product Advantage Group

    Background:

    User is trying to print Spec reports for material check. In this article, we are defining the steps on how to import spec data in Excel from Access database.

    Workaround:

    1. Open Excel, click on data tab.

    2. Get data > from Database > from Access Database



    3. Click on the file which you want to import



    4. Select the table and click on Load.



    5. Report is now ready for the print.

    See Also:

    How to define color for Manual Annotation same as Default Annotation
    Applies To Product(s): OpenPlant PID Version(s): 08.11.10.xxx (SS5) | 08.11.11.xxx(SS6) Environment: Windows 7/8.1/10 (64 bit) Area: Customization Subarea: Dgnlib…
    Last edited over 4 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    • Excel
    • OpenPlant Specification Generator
    • Spec_Gen CE
    • Access database
    • spec data
    • Share
    • History
    • More
    • Cancel
    • Nikhil Salunkhe Created by Nikhil Salunkhe
    • When: Wed, Oct 3 2018 1:32 PM
    • Nikhil Salunkhe Last revision by Nikhil Salunkhe
    • When: Thu, Oct 4 2018 5:44 AM
    • Revisions: 2
    • 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