Re: insert data from an microsoft excel

[John DeSoi <desoi@xxxxxxxxxx>]

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.

http://www.postgresql.org/docs/8.0/interactive/app-psql.html
http://www.postgresql.org/docs/8.0/interactive/sql-copy.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org