Is the syntax correct on that ConnectString? It is not working for me,
tells me the datasource is not found.
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
----- Original Message -----
From: <Thomas Muck <[EMAIL PROTECTED]>>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 8:36 AM
Subject: Re: CSV File Importer
> 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
> >
>
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
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
