On Wed, Feb 16, 2005 at 08:05:55AM -0700, Ed L. wrote:
> On Wednesday February 16 2005 7:48, David Fetter wrote:
> > On 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
> >
> > Once y
On Wednesday February 16 2005 7:48, David Fetter wrote:
> On 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
>
> Once you've upgraded to 8.0x--a good idea anyhow--you can use
> DBI-Link
On 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
Once you've upgraded to 8.0x--a good idea anyhow--you can use DBI-Link
with the DBD::Excel driver.
http://pgfoundry.org/projects/dbi-link
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, ta
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
htt
Title: insert data from an microsoft excel
Is there is way to load data from as Microsoft excel into database tables in postgresql7.4.x
Thx
Rao
