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
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.