Modify Database Content with Excel Spreadsheets
- Last UpdatedMar 14, 2024
- 1 minute read
The content of the database can be editing using Microsoft Excel using the following procedure:
-
Export the content of the database to an Excel spreadsheet.
-
Edit the data as required in the spreadsheet.
-
Import the modified data back into the database.
Only the Dataset attributes and User Column attributes can be changed using this procedure. Read-only data imported from P&ID cannot be updated using this method.