| From: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Excell |
| Date: | 2007-06-20 07:06:07 |
| Message-ID: | 200706200806.07975.garry@schoolteachers.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 20 June 2007 03:09, Bob Pawley wrote:
> Thanks
>
> Does one version of ODBC work for all versions of Excel and Postgresql.
>
> I am wanting to transfer one or two tables from Excel and manipulate the
> information in Postgresql then transfer the results back to Excel as a
> single table.
>
> I am using Excel 2000 and PostgreSql 8.1.
>
Save as CSV from Excel and use Posrgres 'copy' command to import the data,
would be a straightforward solution, works both ways -copy to, copy from.
http://www.postgresql.org/docs/8.2/static/sql-copy.html
Regards
Garry
| From | Date | Subject | |
|---|---|---|---|
| Next Message | EBIHARA, Yuichiro | 2007-06-20 07:31:40 | Re: PostgreSQL Installer for Windows x64 |
| Previous Message | Sergey Konoplev | 2007-06-20 07:04:04 | Re: Dynamic Log tigger (plpgsql) |