Received: from snipe.mail.pas.earthlink.net (snipe.mail.pas.earthlink.net [207.217.120.62]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6KGiga91436 for ; Fri, 20 Jul 2001 12:44:42 -0400 (EDT) (envelope-from tanethq@earthlink.net) Received: from New6 (user-2ivet6t.dialup.mindspring.com [165.247.116.221]) by snipe.mail.pas.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id JAA00900 for ; Fri, 20 Jul 2001 09:44:39 -0700 (PDT) Message-ID: <001f01c1113c$466ad140$6e646464@New6.Travel> From: "Mihai Gheorghiu" To: Subject: Re: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want... Date: Fri, 20 Jul 2001 12:51:25 -0400 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 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Archive-Number: 200107/88 X-Sequence-Number: 1842 Also check (in Excel): File SaveAs SaveAsType:CSV(OS/2orMS-DOS) At least in my case, the resulting file had no quotes. Regards, Mihai -----Original Message----- From: Dave Page To: 'Jeff Eckermann' ; veronique DROUELLE ; pgsql-interfaces@postgresql.org Date: Friday, July 20, 2001 4:00 AM Subject: RE: [INTERFACES] URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want... > > >> -----Original Message----- >> From: Jeff Eckermann [mailto:jeckermann@verio.net] >> Sent: 19 July 2001 18:30 >> To: veronique DROUELLE; pgsql-interfaces@postgresql.org >> Subject: RE: [INTERFACES] URGENT - How to export data from >> EXCEL to Postgr eSQL ou pgaccess as you want... >> >> >> You will need to remove the double quotes that Excel puts >> around all fields with commas in them (seeing this is not >> CSV, I don't know why Excel does this), unless you are happy >> to see those quotes in your data. You will need to check for >> embedded tabs in your data, or your fields may not line up >> correctly. One way to do this: 1. Save the Excel file as CSV >> 2. Remove all tabs from the file (perhaps replace with >> spaces) 3. Open the edited CSV file using Excel 4. Save again >> as tab-delimited text 5. Edit out double quotes and carriage >> returns. You will now have a file suitable for importing using COPY. > >Or just use the Import Wizard in pgAdmin >(www.greatbridge.org/project/pgadmin) which will happily deal with quotes >for you. > >Regards, Dave. > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org