Read the contents of the file into a variable. Then use something like
this.
INSERT INTO myTable (column1, column2, column3)
VALUES
('#listGetAt(cvsfile,1)#','#listGetAt(cvsfile,2)#','#listGetAt(cvsfile,3)#')
Yo
Subject: Re: Looping through a CSV File
If the csv structure will always be the same, you could set up an ODBC
connection and treat it like a table.
- Original Message -
From: "Mike Townend" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday,
Mike Townend wrote:
>Or theres a custom cfx tag called something like ... Cfxcsvtoquery that
>will take a csv file and convert it into a query variable
>
there are mercant text database drivers installed with cf, then u can do
it via ODBC
select * from c:\data\file.csv
z
If the csv structure will always be the same, you could set up an ODBC
connection and treat it like a table.
- Original Message -
From: "Mike Townend" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 10:26 AM
Subject
Or theres a custom cfx tag called something like ... Cfxcsvtoquery that
will take a csv file and convert it into a query variable
HTH
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 16:14
To: CF-Talk
Subject: Looping through a CSV File
I have a C
Treat the file as a list of lists...
List 1 - Delimiter = #Chr(10)##Chr(13)#
And each element of that list is a list with delimeter ,
HTH
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 16:14
To: CF-Talk
Subject: Looping through a CSV File
I ha
6 matches
Mail list logo