From: Mihai Gheorghiu <tanethq@earthlink.net>
To: pgsql-interfaces@postgresql.org
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
Message-ID: <001f01c1113c$466ad140$6e646464@New6.Travel> (raw)
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 <dpage@vale-housing.co.uk>
To: 'Jeff Eckermann' <jeckermann@verio.net>; veronique DROUELLE
<v.drouelle@caramail.com>; pgsql-interfaces@postgresql.org
<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
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: tanethq@earthlink.net
Subject: Re: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...
In-Reply-To: <001f01c1113c$466ad140$6e646464@New6.Travel>
* 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