Re: insert data from an microsoft excel

[Matt Kynaston <matt@xxxxxxxx>]

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)