I am trying to convert a set of CSV files into a HSQLDB database. My first attempt was to fire up `DatabaseManagerSwing` and execute the following code:

```
* *DSV_COL_SPLITTER = ;
\mq /home/michael/workspaces/rds-surveyor/lt/it/NAMES.DAT
commit;

```

Which gets rejected with the error message:

```
java.sql.SQLSyntaxErrorException: unexpected token: *

```

In order to get at least some response from HSQLDB, I tried removing the first line, but this gives just a slightly different error:

```
java.sql.SQLSyntaxErrorException: unexpected token:

```

I then came across sqltool, and after overcoming its various pitfalls (you need the sqltool JAR, as well as the hsqldb JAR of the same version in the same path or somewhere in your classpath) I ran the full code here. The first line got processed as expected, but the `\mq` command fails with a similar error:

```
SEVERE  Cause: SQLSyntaxErrorException: unknown token: 

```

The file I am trying to import looks like this (first few lines shown):

```
CID;LID;NID;NAME;NCOMMENT
25;1;165;Europa;
25;1;167;Italia;
25;1;169;Abruzzo;
25;1;171;Chieti;
25;1;173;Passo Di Lanciano;
25;1;175;Valico Castiglione Messer Marino;
25;1;177;Valico Della Forchetta;

```

What's going wrong here?