> Have you tried using the Text ODBC driver?
>
> It usually opens the files as normal CSVs and you don't have to worry
about
> using CFFile (or CSX_ tags) as you can use it as a datasource
hi,
i have tried, but i couldnt figure out how to use it.
it has to be all automatic, so i thought about using the connectionstring
attribute in cfquery for dsn-less connections.
if i did something like
<cfset constr = "Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt;Persist Security
Info=False;">
<cfquery name="myquery" connectionstring="#constr#" dbtype="ODBC">
but i am not sure how to reference the variables. NO headers, just 7
values.
how could i run a query?
select val1
from textfile
etc etc
thanks
chad
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
