Page 1 of 1

Using Text files as Tables

Posted: Fri Jun 29, 2007 6:39 am
by asitagrawal
Hi,


Has any one tried using a text file ( created using the Sequential File Stage ) by configuring an ODBC for text files ??
My idea is to be able to treat the file with some SQL queries...

Posted: Fri Jun 29, 2007 6:44 am
by ray.wurlod
Perfectly functional, provided your text files meet the requirements of the ODBC text driver (column headings, no "strange" rows).

Just don't complain about the speed.