RE: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Jeff Eckermann'" <jeckermann(at)verio(dot)net>, veronique DROUELLE <v(dot)drouelle(at)caramail(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...
Date: 2001-07-20 07:12:27
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2D38@woody.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> -----Original Message-----
> From: Jeff Eckermann [mailto:jeckermann(at)verio(dot)net]
> Sent: 19 July 2001 18:30
> To: veronique DROUELLE; pgsql-interfaces(at)postgresql(dot)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.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2001-07-20 14:08:33 Re: [BUGS] libpgtcl doesn't use UTF encoding of TCL
Previous Message Tom Lane 2001-07-19 18:58:40 libpgtcl and TCL_ARRAYS