|Subject||Is there an easy way for input rows from a script file?|
|Author||Walter R. Ojeda Valiente|
If I connect to a database "Database1" using ISQL, I can write something like:
SELECT * FROM MyTable;
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"?