Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProStructures
  • Product Communities
ProStructures
ProStructures Wiki 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”
    • Sign In
    • -ProStructures
      • +ProStructures - What's New
      • -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
        • +PS Toggles - 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
          • -iModel - Import/Export
            • How to publish iModel in ProStructures CONNECT Edition?
            • 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
          • +ISM (Integrated Structural Model) - Import/Export
          • +IFC (Industry Foundation Classes) - Import/Export
          • +DWG - Import/Export
          • +ProStructures-Navisworks - Import/Export
          • 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
        • How to enable the Dark theme for 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
    • +Learning Content for ProStructures
    • +ProStructures Licensing
    • +ProStructures Customer Examples / Projects

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

    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”

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

    Overview

    When we try to import i-Model data into MS Access there is one error that occurs for a long name schema.

    This document will explain the workaround for this issue.

    Method

    Please follow the below steps to achieve this.

    1. Open the ODBC Data Source Administrator (64-bit) and browse the i-Model. Please follow the steps as shown in the below image.

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

    3. Select the first option and then click on the OK button.

    4. In the Machine Data Source, tab select iModel 1.6 Data Source and then click on the OK button.

    5. Click on the Select All and then click on the OK button.

    6. For the long name schema, the following error comes.

    7. You can see in the below image all the data get imported except the “SolidGeometricPropertiesSchema…”. Keep MS Access open.

    8. Now, launch MS Excel and go to Data > Get Data > From Other Sources and click on From ODBC.

    9. Select iModel 1.6 Data Source and click on the OK button.

    10. Select the last schema as it contains the data and then click on the Load button.

    11. All the data get imported into MS Excel. Save this file at a known location and close.

    12. In MS Access, go to External Data > New Data Source > From File and click on Excel.

    13. Now here click on the Browse button and browse the Excel file which we have saved just now.

    14. Click on the Next button.

    15. Click on the Next button.

    16. Click on the Next button.

    17. Click on the Next button.

    18. In this dialog box, we can give a required name. Click on the Finish button.

    19. In the below image you can see the data of “Long named schema” get imported into the MS Access.

    In this way, we can import the data of “Long named schema” into the MS Access.

    See Also

    Importing iModel metadata into an Excel sheet:
    https://communities.bentley.com/products/prostructures/w/structural_drafting_and_detailing__wiki/45834/importing-imodel-metadata-into-excel-sheet

    Importing i-Model metadata into MS Access:
    https://communities.bentley.com/products/prostructures/w/structural_drafting_and_detailing__wiki/45378/importing-i-model-metadata-into-ms-access

    • ProStructures
    • does not include invalid characters
    • Excel
    • is not a valid name
    • Long named schema
    • import i-Model data
    • ODBC Data Source Administrator
    • is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long
    • iModel 1.6 Data Source
    • Machine Data Source
    • ProStructures CONNECT Edition
    • punctuation and that it is not too long
    • how to
    • Access
    • MS Access
    • ProSteel
    • ProConcrete
    • ODBC Database
    • SolidGeometricPropertiesSchema
    • Share
    • History
    • More
    • Cancel
    • Vyanktesh Nama Created by Bentley Colleague Vyanktesh Nama
    • When: Thu, Jun 15 2023 4:50 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