I usually do it with some code, using the new connectstring attribute in CF
5 to create a connection to the text file on the fly:
<CFQUERY NAME="rs"
DBTYPE="dynamic"
CONNECTSTRING="Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=C:\myfolder;Extensions=asc,csv,tab,txt;Persist Security
Info=False;">
SELECT myfield1, myfield2 from myfile.csv
</CFQUERY>
<cfloop query="rs">
<CFQUERY NAME="TEST2"
DATASOURCE="mydsn">
INSERT INTO mytable(myfield1, myfield2) VALUES
('#rs.myfield1#','#rs.myfield2#')
</CFQUERY>
</cfloop>
tom
www.basic-ultradev.com
<Bernd VanSkiver <[EMAIL PROTECTED]>> wrote in message
001901c1952b$b37ab3e0$[EMAIL PROTECTED]">news:001901c1952b$b37ab3e0$[EMAIL PROTECTED]...
> Anyone have a tool in ColdFusion that will import a text file in to a
> database? Already looked on the Developer's Exchange (sure is slow
lately)
> and didn't find anything that will work. Just looking for something that
> will parse and import a text file of comma seperated values in to a SQL
> database.
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
