directory: examples\odbc

These scripts illustrate J/ODBC access for various
databases: Access, dBASE, Excel, Text/CSV.

The examples are essentially the same for each database.
Note that there are minor differences in the SQL grammer
for various databases. Each script defines the verb
<demo> that can be used to run through the examples.

The examples use, and may update, datasets in the
examples\data subdirectory of J. You may wish to make
backup copies of these files first.

Before using any ODBC driver (data source) you
should ensure it is first set up in the ODBC data
source administrator available in Control Panel.

To check which drivers are available in J, use ddsrc,
for example:

   ddsrc''
+---------+------------------------------------+
|jdata    |Microsoft dBase Driver (*.dbf)      |
+---------+------------------------------------+
|NorthWind|Microsoft Access Driver (*.mdb)     |
+---------+------------------------------------+
|jexcel   |Microsoft Excel Driver (*.xls)      |
+---------+------------------------------------+
|jaccess  |Microsoft Access Driver (*.mdb)     |
+---------+------------------------------------+
|jtext    |Microsoft Text Driver (*.txt; *.csv)|
+---------+------------------------------------+
