Re: SQL LOAD

In article <3ptjgc$i18$1@mhadg.production.compuserve.com>, Joseph Arcieri <73044.2177@CompuServe.COM> wrote: } }I'm having some difficulty using LOAD or DBLOAD. Here's my problem. }I have a data file with 2 columns, | delimited, that I want to load/update }into the database. } }My statement reads... }load from "data.file" insert into database (column#1, column#2) where }columnX = columnX } }It's the "where columnX = columnX" that's giving me the trouble. I just }can't add the data to the end of the file, I need to update the database }with the "data.file" columns. Any help or suggestions would be }GREEATTLY appreciated! Ok here goes. How about loading your file to a temp table, then select from the temp table and insert into permanent table where columnX = columnX Hope this helps. -- Doug -------------------------------------------------------------------------------- Douglas Probst @ catseye (Home of the crazy cat lady) - Upper Darby, PA INTERNET: doug@catseye.pha.pa.us