Stats

  • Locked Locked
  • Replies 1
  • Subscribers 163
  • Views 15383
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Preferred method of editing Orcad CIS parts database

PaulFrechette
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.
  • oldmouldy
    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.
Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.