KB: Export Workspace Library Components to Access Database

Solution Details

Export Workspace Library Components to Access Database

Extracting Component Data from Managed Libraries

Users need to export part numbers and component data from a Workspace Library (managed libraries stored in a connected Workspace) into an Excel spreadsheet or Access database format. Altium Designer does not provide a direct export to Excel, but the data can be extracted by converting the library into a database-linked format. To extract this data, users must convert the library into an Integrated Library (IntLib), then import it into a Database Library (DbLib) linked to an Access database.

Solution Overview

Follow these steps to export component data:

• Use the Content Cart to collect all components.
• Deliver the cart as an Integrated Library (IntLib).
• Create a new Database Library (DbLib).
• Import the IntLib into the DbLib and link it to a new Access database.

Step-by-Step Instructions

1. While in the Explorer panel, choose your Components Folder or select in the Search tab, select all components in your workspace.
2. Right-click and choose Operations » Add to Content Cart.
   
   
    
   
3. Verify that all components appear in the Content Cart dialog.
4. Change the destination to IntLib and choose a location to save it.
5. Select Deliver Cart. This may take up to 30 minutes depending on the number of components.
   
   
    
   
6. Go to File » New » Library, select Database, choose Database Library, and click Create.
   
    
   
   
7. In the Projects panel, open the new DbLib file.
8. Select Tools » Import From Integrated Library.
   
    
   
   
9. Choose New Access Database and specify a location for the Access file.
   
    
   
   
10. Specify a location for the DbLib file (this can be arbitrary).
11. Click Add and select the IntLib file generated earlier.
12. Click Next to complete the import.

Altium will generate a DbLib file linked to the Access database. The Access file will contain a table with all component parameters.

Additional Notes

• This method provides a structured export of component data suitable for reporting or integration.
• Ensure you have write permissions for the destination folders.
• Large libraries may take longer to process; allow sufficient time for the export.

Further Reading

• Building & Maintaining Your Components and Libraries