How to export to Excel or Text files

You can export data to Excel spreadsheets and ascii text files. To do this you must first figure out which file in Computer Admin to export. If you want a list of computers exported then you should start with the Comp.CAP file. If you are interested in a list of your software then start with the Sof.CAP file. Peripheral information must be exported from the Periph.CAP file.You can export several files at once by using relationships already created.

Once you decide which file best suits your needs you are ready to export. Open Computer Admin and from the Window Menu select which file you wish to export.

Once that file is brought to the front you will see a splash screen.

Go to the File Menu and choose Export Records...

In the next window you will be prompted to save the file...

From the Type menu choose your file type (Tab-Separated or Comma-Separated are both text formats, SYLK for Excel, etc.)

After you select your export file type and name you will see the Field selection export dialog

Fields are listed on the left. Select the field to be exported and then click the move button. Once you have moved all the fields that you want to export so that they are listed on the right click the Export button.

This is basic export information. If you need a more customized export please contact CG Software. We can create auto-export in custom format.

CA Pro | CA Lite | Free Demo | Buy Now! | Free Newsletter | FAQ | Privacy | About Us | Press