Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to Import Excel Into PostgreSQL database

How to Import Excel Into PostgreSQL database

From
"Venkat Rao Tammineni"
Date:
<div class="Section1"><p class="MsoNormal"><span style="font-family:"Courier New";color:#4F81BD">Dear All,</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New";color:#4F81BD"> </span><p class="MsoNormal"><span
style="font-family:"CourierNew";color:#4F81BD">  I using PosgreSql8.1.I want to import Excel into PostgreSQL database.
Isthere any way to import ? .</span><p class="MsoNormal"><span style="font-family:"Courier
New";color:#4F81BD"> </span><pclass="MsoNormal"><span style="font-family:"Courier New";color:#4F81BD">Please anyone can
guideme.</span><p class="MsoNormal"><span style="font-family:"Courier New";color:#4F81BD"> </span><p
class="MsoNormal"><spanstyle="font-family:"Courier New";color:#4F81BD">I am waiting for your great response.</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New";color:#4F81BD"> </span><p class="MsoNormal"><span
style="font-family:"CourierNew";color:#4F81BD">Thanks</span><p class="MsoNormal"><span style="font-family:"Courier
New";color:#4F81BD">Venkat.</span></div>

Re: How to Import Excel Into PostgreSQL database

From
"A. Kretschmer"
Date:
In response to Venkat Rao Tammineni :
> Dear All,
> 
>  
> 
>   I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is
> there any way to import ? .

Create a CSV-File and import that with COPY.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: How to Import Excel Into PostgreSQL database

From
"Venkat Rao Tammineni"
Date:
Hi ,
Thanks a lot.

Regards
Venkat.

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of A. Kretschmer
Sent: Wednesday, December 24, 2008 2:54 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] How to Import Excel Into PostgreSQL database

In response to Venkat Rao Tammineni :
> Dear All,
> 
>  
> 
>   I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is
> there any way to import ? .

Create a CSV-File and import that with COPY.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: How to Import Excel Into PostgreSQL database

From
Tk421
Date:
    Try this: <a class="moz-txt-link-freetext"
href="http://sqlmanager.net/products/postgresql/manager/">http://sqlmanager.net/products/postgresql/manager/</a><br/>
   <br />     It's an application that includes a lot of tools for importing and exporting databases. It's the best
tooli've used for these kind of actions, and to manage postgreSQL databases<br /><br /> Venkat Rao Tammineni escribió:
<blockquotecite="mid:002b01c96596$3165e170$9431a450$@com" type="cite"><style>
 
<!--/* Font Definitions */@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}/* Style Definitions
*/p.MsoNormal,li.MsoNormal,
div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;}
.MsoChpDefault{mso-style-type:export-only;}
@page Section1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1{page:Section1;}
--> </style><div class="Section1"><p class="MsoNormal"><span style="font-family: "Courier New"; color: rgb(79, 129,
189);">DearAll,</span><p class="MsoNormal"><span style="font-family: "Courier New"; color: rgb(79, 129,
189);"> </span><pclass="MsoNormal"><span style="font-family: "Courier New"; color: rgb(79, 129, 189);">  I using
PosgreSql8.1.Iwant to import Excel into PostgreSQL database. Is there any way to import ? .</span><p
class="MsoNormal"><spanstyle="font-family: "Courier New"; color: rgb(79, 129, 189);"> </span><p class="MsoNormal"><span
style="font-family:"Courier New"; color: rgb(79, 129, 189);">Please anyone can guide me.</span><p
class="MsoNormal"><spanstyle="font-family: "Courier New"; color: rgb(79, 129, 189);"> </span><p class="MsoNormal"><span
style="font-family:"Courier New"; color: rgb(79, 129, 189);">I am waiting for your great response.</span><p
class="MsoNormal"><spanstyle="font-family: "Courier New"; color: rgb(79, 129, 189);"> </span><p class="MsoNormal"><span
style="font-family:"Courier New"; color: rgb(79, 129, 189);">Thanks</span><p class="MsoNormal"><span
style="font-family:"Courier New"; color: rgb(79, 129, 189);">Venkat.</span></div></blockquote><br /><br />