Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki How to add Parts Data from MDB file data to existing Parts Database MDB file - Promis.e CONNECT
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • -CONNECT Edition - Promis.e
        • +Administration Features - Promis.e CONNECT
        • +Automation Features - Promis.e CONNECT
        • +Component Features - Promis.e CONNECT
        • -Component Management - Promis.e CONNECT
          • +Catalog Manager - Component Management - Promis.e CONNECT
          • Columns missing from dialogs, error messages in Promis.e Connect
          • +Create Symbol - Component Management - Promise CONNECT
          • +Family Creation - Component Management - Promis.e CONNECT
          • -Parts Database - Component Management - Promis.e CONNECT
            • How to add Custom Parts Database Field into Parts Database Manager dialog - Promis.e CONNECT
            • How to add Parts Data from MDB file data to existing Parts Database MDB file - Promis.e CONNECT
            • How to create Parts Database Path using MDB file in Promise CONNECT
            • How to create Parts Database Path using SQL Database in Promise CONNECT
            • How to navigate to Part Database manager
            • No Browse button for custom mode symbols on Parts Database Manager in Promis.e Connect
          • +Replace - Component Management
          • +Terminal Pin-Plug Manager - Component Management - Promise CONNECT
        • +Database Platform Support - Promis.e CONNECT
        • +Drawing Management - Promis.e Connect
        • +Installation_Configuration - Promis.e CONNECT Edition
        • +Maintenance Features - Promis.e CONNECT
        • +Migration - Promis.e CONNECT
        • +OS & Hardware Support - Promis.e CONNECT
        • +Panel Layout Mode - Promis.e CONNECT
        • +Power Platform Support - Promis.e CONNECT
        • +Print and Plot features Promis.e CONNECT
        • +Project Management - Promis.e CONNECT
        • +ProjectWise Integration - Promis.e CONNECT
        • +Reports_Output Features - Promis.e CONNECT
        • +Resolved issues in Promis.e Releases
        • +Wire Numbering - Promis.e CONNECT
        • +Wiring Feature - Promis.e CONNECT
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    How to add Parts Data from MDB file data to existing Parts Database MDB file - Promis.e CONNECT

      Product(s): Promis.e CONNECT Edition
      Version(s):  10.00.XX.XX to 10.07.XX.XX
      Environment:  NA
      Area:  Component Management
      Subarea:  Parts Database 

    Background:

    Users sometimes may need to copy Parts Database records from an MDB file to the existing Parts Database which is being used with Promis.e. This is usually needed if you are trying to use Part Records from a new Catalogs. 

    Steps to Accomplish

    Note: The below steps require MS Office Access, hence check if you have it installed on your machine before proceeding.


    1. Create a copy of the already existing parts database that is currently being used by Promis.e and into which the new Part Number records need to be added.  And open the Table Associated with part Number records in both the MDB files. 


    2. Create a copy of the already existing parts database that is currently being used by Promis.e and into which the new Part Number records need to be added.  And open the Table Associated with part Number records in both the MDB files.



    3. Then make sure that all the Columns are the same for both the MDB files and are in the same sequence. This needs to be checked correctly for each column in both the MDB files so that the data maintained with the same information. If there is any difference the column needs to be added accordingly in both the MDB files. 

    4. Once the Columns are maintained, the next is to copy the data fields from the Source MDB file to Target MDB by selecting all the details as required. Make sure that the Column header is not selected.



    5. After the part details have been copied open the Target MDB file and past the parts data below the existing parts data.




    6. Now copy the MDB file where the Parts Data is copied and replace it with the Parts Database MDB file currently being used by Promis.e as referred to in step 1.

    Note: Before copying MDB file, if the existing file is currently being used by Promis.e then close Promis.e before making the changes.

    Alternative Steps


    Alternatively, the user can also use SQL Management Studio (SSMS) to copy the data from Source MDB to Target MDB. The user can refer to the below link for the details on the same.


    https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-mysql-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15  



    https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/choose-a-destination-sql-server-import-and-export-wizard?view=sql-server-ver15


    See Also, 

    How to create Parts Database Path using MDB file in Promise CONNECT
    Product(s): Promis.e CONNECT Version(s): 10.00.XX.XX to 10.05.XX.XX Environment: N/A Area: Component Management Subarea: Parts Database Background…
    Last edited over 3 years ago in OpenUtilities > OpenUtilities Wiki

      Original Author: Satish Saptasagar
    • parts database
    • promise CONNECT
    • Merge
    • partnumber
    • how to
    • en
    • Component Management
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Wed, Mar 10 2021 7:56 AM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Wed, Mar 10 2021 7:58 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