Importing a .Dat file into a DB using Coldfusion

[Miller1229]

We are currently receiving a txt file from another DB. We need to import this
file into a Database using coldfusion. The delimiter that is used is |. The
first row is the column header. Any help would be appreciated.

[Brad]

I have always used the CFHTTP tag to read delimited flat files and then you
can loop the results into a query that inserts into a database. By default
the first row is used for column names and you specify the delimiter. Works
really well.

.....Brad


"Miller1229" <webforumsuser@macromedia.com> wrote in message
news:cvdho4$6bc$1@forums.macromedia.com...
We are currently receiving a txt file from another DB. We need to import
this
file into a Database using coldfusion. The delimiter that is used is |.
The
first row is the column header. Any help would be appreciated.

[LeadFoot]

Using CFFILE to read the file in question is the only solution that I can think
of. A couple of things need to be addressed first:

1) What DB are you using (SQL Server, Oracle, Access, etc.)
2) Does the table that is being inserted into already exist?

If the table already exists, you will need to do some checking to see if the
values being imported are unique. If they are, you would do an insert. If the
value already exists, you would need to do an update (if that is what you want
to do).