Received: from intergate.rccd.cc.ca.us (intergate.rccd.cc.ca.us [204.69.0.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1GHUix43359 for ; Fri, 16 Feb 2001 12:30:52 -0500 (EST) (envelope-from jcuz@rccd.cc.ca.us) Received: from ismv.rccd.cc.ca.us ([207.233.113.253]) by intergate.rccd.cc.ca.us (8.9.1a/8.9.1) with ESMTP id JAA02268 for ; Fri, 16 Feb 2001 09:24:30 -0800 (PST) Message-Id: <4.3.2.7.2.20010216092952.00b85ee8@rccd.cc.ca.us> X-Sender: jcuz@rccd.cc.ca.us X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Fri, 16 Feb 2001 09:32:06 -0800 To: pgsql-php@postgresql.org From: "Julio Cuz, Jr." Subject: How do I import this? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200102/20 X-Sequence-Number: 159 Hi-- I'm having problems importing a file that contains the following data (close to 500 lines): sample: ---------------- "Heritage";"5/2/00";"EOPS";12/30/1899 15:00:00;12/30/1899 17:00:00;12/30/1899 17:00:00;12/30/1899 15:00:00;"Claudette Ellis";"Riverside";"cellis";"8123";100144;5/2/2000 0:00:00;"EOPS OPR Review Staff Mtg";;"12";"12 Chairs and enough tables (set up) in a hollow square"; ---------------- The delimiter is ";" and I'm using this: COPY FROM INTO USING DELIMITER |;| And it says bad format...Help! Julio Cuz, Jr. Riverside Community College jcuz@rccd.cc.ca.us