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

JDRING

Text File Input to Database Output

Postby JDRING » 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!!!!

User avatar
DataMystic Support
Site Admin
Posts: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Fri Oct 03, 2003 5:32 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “FileWatcher, DirDate and other Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest