If I connect to a database "Database1" using ISQL, I can write something like:

OUTPUT MyFile.DAT;

SELECT * FROM MyTable;

OUTPUT;

And all the rows of "MyTable" will go to the text file "MyFile.DAT". That's ok and works fine.

But now, I want to connect to "Database2", which also have a table called "MyTable" and with the same structure.

After that, I want to insert into "MyTable" (of "Database2") the rows contained in "MyFile.DAT"

How can I do such thing without a lot of effort writing an INSERT command in each line of "MyFile.DAT"?

Greetings.

Walter.