From: Jeff Eckermann <jeckermann@verio.net>
To: veronique DROUELLE <v.drouelle@caramail.com>
To: pgsql-interfaces@postgresql.org
Subject: RE: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...
Date: Thu, 19 Jul 2001 12:30:17 -0500
Message-ID: <08CD1781F85AD4118E0800A0C9B8580B094B4A@NEZU> (raw)
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.
> -----Original Message-----
> From: Jeremy Buchmann [SMTP:jeremy@wellsgaming.com]
> Sent: Thursday, July 19, 2001 10:13 AM
> To: veronique DROUELLE; pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] URGENT - How to export data from EXCEL to
> PostgreSQL ou pgaccess as you want...
>
>
>
> > Hello,
> >
> > I'd like know how recover data from EXCEL table. This table
> > contains values of a ELISA plate with coordonates (A1,
> > A2...A12....H12).I'm explaining: columns are 1..12 and rows
> > are A .. H and I'd like recover values of this table with
> > coordonates. For example 4.256 for A4! and this, for the 96
> > values...
> >
> > I know CSV format exists but I don't know how recover CSV
> > enregistered data.
>
> Save the Excel table as tab-delimited text and then you can use the COPY
> command to dump it into PostgtreSQL.
>
> -- Jeremy [jeremy@wellsgaming.com]
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jeckermann@verio.net, v.drouelle@caramail.com
Subject: RE: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...
In-Reply-To: <08CD1781F85AD4118E0800A0C9B8580B094B4A@NEZU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox