Home > Community > Forums > PCB Design > Preferred method of editing Orcad CIS parts database

Email

* Required Fields

Recipients email * (separate multiple addresses with commas)

Your name *

Your email *

Message *

Contact Us

* Required Fields
First Name *

Last Name *

Email *

Company / Institution *

Comments: *

 Preferred method of editing Orcad CIS parts database 

Last post Wed, May 8 2013 4:12 AM by oldmouldy. 1 replies.
Started by PaulFrechette 07 May 2013 04:53 PM. Topic has 1 replies and 594 views
Page 1 of 1 (2 items)
Sort Posts:
  • Tue, May 7 2013 4:53 PM

    Preferred method of editing Orcad CIS parts database Reply
    I am looking for suggestions on what software I can use to modify part attributes that are in my Orcad CIS database.  For example, a resistor manufacturer has changed there numbering scheme.  So, I would like to open the database in a spreadsheet format and do a global replace of text for these parts.  I am using Microsoft SQL Server 2008 and I am not a database expert.  Just looking for an easy way to edit.
    Filed under:
    • Post Points: 20
  • Wed, May 8 2013 4:12 AM

    • oldmouldy
    • Top 10 Contributor
    • Joined on Tue, Jul 15 2008
    • Woking, Surrey
    • Posts 1,270
    • Points 21,760
    Re: Preferred method of editing Orcad CIS parts database Reply
    The database is the "other side" of the ODBC interface so Capture CIS has no means to modify it. If you can't use the SQL tools to modify the database through the SQL Server "management console", you could link Microsoft Access to the SQL Server database through ODBC and then use the Microsoft Access interface and commands to modify the data.
    • Post Points: 5
Page 1 of 1 (2 items)
Sort Posts:
Started by PaulFrechette at 07 May 2013 04:53 PM. Topic has 1 replies.