Обсуждение: Re: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...
Re: URGENT - How to export data from EXCEL to Postgr eSQL ou pgaccess as you want...
От
"Mihai Gheorghiu"
Дата:
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