Received: from bush.rutgersinsurance.com (rutgersinsurance.com [38.138.71.194]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1GHv1x45904 for ; Fri, 16 Feb 2001 12:57:01 -0500 (EST) (envelope-from aalang@rutgersinsurance.com) Received: from 6014cwpza006 (adam.rutgersinsurance.com [10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id NAA17893 for ; Fri, 16 Feb 2001 13:00:14 -0500 Message-ID: <02e501c09842$1c3b84a0$330a0a0a@rutgersinsurance.com> From: "Adam Lang" To: References: <4.3.2.7.2.20010216092952.00b85ee8@rccd.cc.ca.us> Subject: Re: How do I import this? Date: Fri, 16 Feb 2001 12:58:47 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/21 X-Sequence-Number: 160 Are the date fields meshing? I notice you have "5/2/00" If that is date in your database, it won't take it because of the quotes. Check to make sure all your data is formatted correctly. Also, the stuff surrounded by quotes, the quotes will be inputted into the fields also. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Julio Cuz, Jr." To: Sent: Friday, February 16, 2001 12:32 PM Subject: [PHP] How do I import this? > 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