×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Import-export SAP2000 to excel or to acess with the OAPI

Import-export SAP2000 to excel or to acess with the OAPI

Import-export SAP2000 to excel or to acess with the OAPI

(OP)
Hello. I need to export and import data from a SAP2000 model to Excel or to a sap.mdb file. I consulted the OAPI manual but did not find anything. Does anybody know how I could the import export commands with OAPI?
thanks

RE: Import-export SAP2000 to excel or to acess with the OAPI

hi!

in Edit Menu, Choose Interactive database editing, then choose tables and press OK. In new opened window and with using the button "To Excel" and "From Excel" you can interactive data between excel and sap.

RE: Import-export SAP2000 to excel or to acess with the OAPI

(OP)
thanks for your reply. I already know hot to importa and export with the user interface. The thing is, I would like to import and export with code written in Visual Basic for Applications (VBA). SAP2000 supports this lenguage, with OAPI. The OAPI manual explains several commands, but the commands referring to import and export are missing. thanks again, anyway!!

RE: Import-export SAP2000 to excel or to acess with the OAPI

Hi.if you find how import or export information by oapi ,tell we how you do this work.tancks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources