| From: | Matt Kynaston <matt(at)kynx(dot)org> |
|---|---|
| To: | |
| Cc: | Nageshwar Rao <NageshwarR(at)PLANETASIA(dot)COM>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: insert data from an microsoft excel |
| Date: | 2005-02-16 13:32:25 |
| Message-ID: | 42134B69.1030101@kynx.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John DeSoi wrote:
>
> On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:
>
>> Is there is way to load data from as Microsoft excel into database
>> tables in postgresql7.4.x
>
>
>
> Sure. Export the data into a CSV file. Then import it using psql and
> the \COPY command.
>
Or if it's something that needs automating, take a look at the ODBC
driver. There's a howto on using VBA to connect Access to Postgres -
Excel will be similar:
http://gborg.postgresql.org/project/psqlodbc/
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-accessvba
Matt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Naschenweng | 2005-02-16 13:34:09 | Re: ERROR: cannot alter type of a column used by a view or rule |
| Previous Message | Stephan Szabo | 2005-02-16 13:25:18 | Re: ERROR: cannot alter type of a column used by a view |