Whats your opinion?
i have a text file with data that goes to two tables the first two lines goes to one then i have a few rows which goes to another then a statement end to signal the end of the transaction.
although this can be done using java i was wondering if anyone had any ideas if this can be done using sql statements.
# 4
I would add, if the main reason of using txtfiles is that you can't or don't want to install a database, then consider using MS Access MDB files. You can access them by a JDBC-ODBC bridge.Anyway, if it was me, I should install a real RDBMS anyhow and make use of it ;)
# 5
> I would add, if the main reason of using txtfiles is> that you can't or don't want to install a database,I didn't consider that interpretation.In windows there is a odbc text file driver (direct to a text file) but it is very, very limited.
