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 [EMAIL PROTECTED])
