I have the same situation. What I did is set up an Access DB that uses the
text file as the source of the table. The text file is copied over
automatically, then I have a simple update page that pulls the info out of
the Access table into SQL.
Hope this helps!!!
CW
-Original Message-
Peter,
Unfortunately yes. Its a really useful tag for several projects I've
worked on. Fortunately we run WinD'ohs servers here so its not as
critical to us.
The best way I can see ho to do this is to upload the file with cffile
action='upload", then read the file using CFFILE ACTION="Read".
I've been trying to figure out a method to suck the contents of a comma
delimited text file into a SQL database on an automated basis. Is there some
method of doing this via CF? I've looked in the devex for a tag but don't
see any.
I'm getting a text file every night from an offsite source and
(at least) 2 ways of doing this...
1/ Use cffile and lsit functions in cf to import line by line - inefficient
and slow if you are importing a large ammount of data.
2/ Create a dts package in sqlserver and set it up as an automated process
(or use cfexecute and dtsrun) in sqlserver.
If doing
And
3/ Set up a schema.ini file in the directory where your text file will be,
set up a text file datasource, and treat it like a read-only DSN
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2001 14:51
To: CF-Talk
Subject: RE: Tag or function to
Paul,
Have a look at Nate Weiss' custom CFX tag called CFX_CSVToQuery. You can
get it from his website. Here's the direct URL:
http://www.nateweiss.com/taggallery/CFXQueryColumns\CFX_QueryColumns.zip.
He also has the documentation on-line for the tag:
on a "good" day CFHTTP will return the records from a CSV file as a complete
query When it works, it is quick and simple. I have had my best
results working with csv files that I built by script.
http://cfhub.com/advanced/cfhttp/query.cfm
3/Third way: use CFHTTP to turn the file into a query and make a SQL statement to copy
the data into your database
4/Fourth way: use CFEXECUTE to call a Perl script
5/Pull the data straight from Excel as an ODBC datasource
We've used both methods 3 4. The Perl script is by far faster, more
I tried this tag but it is NT only. Not Unix or Linux :-(
At 11:30 AM 2/16/01 -0500, Larry C. Lyons wrote:
Paul,
Have a look at Nate Weiss' custom CFX tag called CFX_CSVToQuery. You can
get it from his website. Here's the direct URL:
9 matches
Mail list logo
