Text File Input to Database Output

Discuss our other products here. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
JDRING

Text File Input to Database Output

Post by JDRING »

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!!!!
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post 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.
Post Reply