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
