Is there is way to load data from as Microsoft excel into database tables in
postgresql7.4.x
Thx
Rao
[PostgreSQL] insert data from an microsoft excel
| Tweet |
|
Search Discussions
-
John DeSoi at Feb 16, 2005 at 12:48 pm ⇧ 
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
-
Matt Kynaston at Feb 16, 2005 at 1:32 pm ⇧
John DeSoi wrote:Or if it's something that needs automating, take a look at the ODBCOn 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.
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
-
David Fetter at Feb 16, 2005 at 2:49 pm ⇧
Once you've upgraded to 8.0x--a good idea anyhow--you can use DBI-LinkOn Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
Is there is way to load data from as Microsoft excel into database
tables in postgresql7.4.x
with the DBD::Excel driver.
http://pgfoundry.org/projects/dbi-link/
Cheers,
D--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote! -
Ed L. at Feb 16, 2005 at 3:06 pm ⇧
Wouldn't ODBC work for this?? I've pulled into Excel from Pg asOn Wednesday February 16 2005 7:48, David Fetter wrote:On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:Once you've upgraded to 8.0x--a good idea anyhow--you can use
Is there is way to load data from as Microsoft excel into
database tables in postgresql7.4.x
DBI-Link with the DBD::Excel driver.
far back as pg 6.5, but never tried pushing from Excel into
Pg...
Ed
-
David Fetter at Feb 16, 2005 at 3:33 pm ⇧
DBI-Link makes it pretty trivial to pull any tabular data intoOn Wed, Feb 16, 2005 at 08:05:55AM -0700, Ed L. wrote:On Wednesday February 16 2005 7:48, David Fetter wrote:Wouldn't ODBC work for this??On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:Once you've upgraded to 8.0x--a good idea anyhow--you can use
Is there is way to load data from as Microsoft excel into
database tables in postgresql7.4.x
DBI-Link with the DBD::Excel driver.
It probably would.
I've pulled into Excel from Pg as far back as pg 6.5, but never
tried pushing from Excel into Pg...
PostgreSQL :)
Cheers,
D--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
Related Discussions
Discussion Navigation
| view | thread | post |
Discussion Overview
| group | pgsql-general
 |
| categories | postgresql |
| posted | Feb 16, '05 at 11:16a |
| active | Feb 16, '05 at 3:33p |
| posts | 6 |
| users | 5 |
| website | postgresql.org |
| irc | #postgresql |
5 users in discussion
