Martin,
Unaware of the possibility of creating ODBC connections to DBF files, I once
create a DBF parser for a client:
http://www.jsoftware.com/svn/DanBron/trunk/general/parse/dbf.ijs
The EMP dBASE is a DBF file; I don't know if your "real" problem is too, but if
it is, you can use my script instead of the ODBC
interface:
dbf2mat jpath '~system\examples\data\emp.dbf'
+----------+----------+------+---------+------+----+------+----------+
|FIRST_NAME|LAST_NAME |EMP_ID|HIRE_DATE|SALARY|DEPT|EXEMPT|INTERESTS |
+----------+----------+------+---------+------+----+------+----------+
| Tyler |Bennett |E10297|19770601 |32000 |D101|Y | |
+----------+----------+------+---------+------+----+------+----------+
| John |Rappl |E21437|19870715 |47000 |D050|Y | 1|
+----------+----------+------+---------+------+----+------+----------+
| George |Woltman |E00127|19820807 |53500 |D101|Y | 2|
+----------+----------+------+---------+------+----+------+----------+
| Adam |Smith |E63535|19880115 |18000 |D202|N | |
+----------+----------+------+---------+------+----+------+----------+
|*Claire |Buckman |E39876|19851123 |27800 |D202|Y | |
+----------+----------+------+---------+------+----+------+----------+
| David |McClellan |E04242|19820727 |41500 |D101|Y | 3|
+----------+----------+------+---------+------+----+------+----------+
| Rich |Holcomb |E01234|19830601 |49500 |D202|Y | |
+----------+----------+------+---------+------+----+------+----------+
| Nathan |Adams |E41298|19880215 |21900 |D050|N | |
+----------+----------+------+---------+------+----+------+----------+
| Richard |Potter |E43128|19860412 |15900 |D101|N | |
+----------+----------+------+---------+------+----+------+----------+
| David |Motsinger |E27002|19850505 |19250 |D202|N | |
+----------+----------+------+---------+------+----+------+----------+
| Tim |Sampair |E03033|19871202 |27000 |D101|Y | |
+----------+----------+------+---------+------+----+------+----------+
| Kim |Arlich |E10001|19850730 |57000 |D190|Y | |
+----------+----------+------+---------+------+----+------+----------+
| Timothy |Grove |E16398|19850121 |29900 |D190|Y | |
+----------+----------+------+---------+------+----+------+----------+
-Dan
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
