Q.  I am trying to create a clean, error-free MS Access database for my 
    CD library using AudioStation DBF files.  I have succeeded in 
       - importing TRACK.DBF, ALBUM.DBF and ARTIST.DBF files into EXCEL,
       - linking them to Access tables, and
       - editing them to correct typos, naming variations, etc.
    I need to convert these files back into .DBF files and create new .CDX 
    files compatible with AudioStation.
 
    Which .DBF file format is used by AudioStation?
    How can I rebuild the .CDX files so AudioStation can use the corrected
    files?
 

A.  Here are two methods:

    1. In order to print the AudioStation contents (non-Atron specific), 
       from within AudioStation click on 'File' and select 'Print List 
       Contents'. The program will print the contents of the Library folder
       selected from the left pane under 'Library'. If you want to print all
       titles, please focus / select 'ALL Tracks' from the left pane.   


    2. AudioStation uses a FoxPro compatible format.  The easiest way to 
       manage the index files (.cdx) is to let Access do it and use the Link
       Tables function to open the index along with the dbf file.

         While it is very simple to link most of the tables into Access, 
         the critical table TRACK.DBF is not recognized by MS Access 
         (Office 2000).  You can import it into Excel and from there into 
         Access, but by then you have lost the active link.  This means each
         time you make a change to in AudioStation, you need to go through 
         the import process again.  
 
___________________________________________________________________________