Besides basic data import/export, it is possible to work with 3rd part database (Access, Excel or Lotus) using a script. This may be quite useful if it is not possible to find the exact correspondence between your DB fields and fields of the DB you need to export to.
You can also use SQL queries to work with external database. For more information review the "External DB SQL Query" and "For each record from SQL query (External DB)" cycle articles.
The easy way to understand script usage is to give an example. For instance, there is an Excel-based DB stored at C:\example.xls" Suppose the main sheet of this Excel document has the following cells:
We need to get currency rate from it and fill in this document using data from our database.
If everything was done correctly, the file example.xls should contain the following data:
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.