Re: Excell - Mailing list pgsql-general

From Bob Pawley
Subject Re: Excell
Date
Msg-id 011e01c7b2e0$0a58f910$8e904618@owner
Whole thread Raw
In response to Excell  (Bob Pawley <rjpawley@shaw.ca>)
Responses Re: Excell  (David Gardner <david@gardnerit.net>)
Re: Excell  (Garry Saddington <garry@schoolteachers.co.uk>)
Re: Excell  (Ireneusz Pluta <ipluta@wp.pl>)
List pgsql-general
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.

Bob


----- Original Message -----
From: "David Gardner" <david@gardnerit.net>
To: "Postgresql" <pgsql-general@postgresql.org>
Sent: Tuesday, June 19, 2007 4:56 PM
Subject: Re: [GENERAL] Excell


> Agreed ODBC is the way to go, depending on what you are doing, Access may
> be helpfull as an intermediate step.
>
> Joshua D. Drake wrote:
>> Bob Pawley wrote:
>>>
>>> Hi All
>>>  Is there a fast and easy method of transferring information between MS
>>> Excel and PostgreSQL??
>>
>> odbc?
>>
>> Joshua D. Drake
>>
>>
>>>  Bob Pawley
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>


pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Iterate over an array in stored procedure
Next
From: David Gardner
Date:
Subject: Re: Excell