CFDJ Vol. 2 , Issue 12 - pg.39
ColdFusion Techniques: Test & Excel ODBC Listing 1
<cfquery name="Q1" datasource="CFDJ" dbtype="ODBC">
create table mytable.txt
    (Field1 char(10),
     Field2 date,
     Field3 integer)
</cfquery>
<cfloop index="Indx" from="1" to="5">
<cfquery name="Q2" datasource="CFDJ" dbtype="ODBC">
    insert into mytable.txt
      (Field1, Field2, Field3)
    values
      ('Ray',#CreateODBCDate(Now())#,#Indx#)
</cfquery>
</cfloop>

Listing 2
"Field1","Field2","Field3"
"Ray",9/20/2000 0:00:00,1
"Ray",9/20/2000 0:00:00,2
"Ray",9/20/2000 0:00:00,3
"Ray",9/20/2000 0:00:00,4
"Ray",9/20/2000 0:00:00,5

Listing 3
<cfif FileExists("c:\inetpub\wwwroot\cfdj\mytable.txt")>
<cfquery name="Q0" datasource="CFDJ" dbtype="ODBC">
drop table mytable.txt
</cfquery>
</cfif>

Listing 4
<cfquery name="Q1" datasource="CFDJ" dbtype="ODBC">
select *
from address.txt
</cfquery>
<cfoutput>#Q1.ColumnList#</cfoutput><br>
<cfoutput query="Q1">
#Q1.Name#,
#Q1.Address#,
#Q1.City#,
#Q1.State#,
#Q1.Zip#,
#Q1.Phone#<br>
</cfoutput>

Listing 5
<cfquery name="Q0" datasource="CFDJ" dbtype="ODBC">
drop table mytable
</cfquery>