Page 1 of 1

Text File Input to Database Output

Posted: Sat Sep 13, 2003 10:52 am
I'm trying to figure out how to use TPP and/or DPP to extract data from a .txt file and insert the results into a SQL or Access Database. I have data pipe and am running the latest Windows, so I Know it's not a windows thing. The instructions say that one can use a DB extract Filter in TPP to get data out and then use a subsequent one to insert it into a new table. However, I can't seem to make it work.... hey SIMON, HELLLLLP!!!!

Posted: Fri Oct 03, 2003 5:32 am
by DataMystic Support
Hi - you don't need DPP for this.

With the first database filter, have an input text of

select * from tablename;

set the database filter output format to 'insert script', for the new tablename.

The result is a series of INSERT INTO ... statements. Add a second database filter, this one pointing to the new database.

When you run this the data will be selected, and copied to database 2.