This program will convert Access database tables and queries to CASL (Code and Data). It allows you to select the fields from the table or query, build your own SQL queries, and it generates the Code in a CASL cpk file (both variables and dbfile definition). You can also use it to create index files for multiple key tables. You can even use the preview feature to view the results of your conversion before performing it. Once you have created your CDB file you can use ConvertCDI2PDB to create a PDB file.

This tool is a command line equivalent of the MDB 2 CASL converter. Using this tool you can script batch conversions of Access databases tables (or SQL queries) or create index tables. Includes a sample batch file and an interactive Batch builder (in case you don't know much about building DOS batch files).

However, if you do understand batch files then using the scripting language is very simple.

Sample Batch Script @Echo Off @Echo Converting... Rem *************************************************************************** Rem This Section Creates the Property Table and all the indexes Rem *************************************************************************** @Echo Property... CmdCDB /d:C:\Clients\Zagat\0014.mdb /t:Property /c:C:\Clients\Zagat\Property.cdb ConvertCDI2PDB "C:\Clients\Zagat\Property.cdb" -CreatorID Zgat @Echo Property Indexes... @Echo Name... CmdCDB /d:C:\Clients\Zagat\0014.mdb /t:Property /i:C:\Clients\Zagat\PropA_Idx.cdb /p:persistentid /k:PropertyName ConvertCDI2PDB "C:\Clients\Zagat\PropA_Idx.cdb" -CreatorID Zgat

Example Script

*Note - When used with ConvertCDI2PDB you can create CDB files from an Access database and then convert the files to PDB. Offering a simple way to convert an entire projects files and data to Palm format.

This tool is what makes the whole package worthwhile. CDB Browser lets you browse CASL (CDB) files, edit and search them. You can also create Layout files to save the column headers, size and even the CDB file location. This tool is essential for working with CASL. Once you have it you'll wonder how you got by before.