From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Bob Powell <bob(at)hotchkiss(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Export From Postresql to a DBF File Format |
Date: | 2002-04-15 17:25:09 |
Message-ID: | 20020415172509.76152.qmail@web13409.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
MS Access can be used as a flexible tool for reshaping
data. Using MS Access on the client-side, I am able
to link to PostgreSQL tables via ODBC. Once
connected, I export data into many data formats (text
files, .dbf, Paradox, FoxPro, Excel, etc). If I need
to change the format or values of the data itself, I
do so in a query, and export the query results.
You can use this same method with other ODBC compliant
databases such as Paradox. (I would _not_ recommend
Lotus Approach for this.)
Best of luck,
Andrew Gould
--- Bob Powell <bob(at)hotchkiss(dot)org> wrote:
> Hello Everyone:
>
> I've searched the FAQ's and found no references to
> this. I would like to be able to create a standard
> .DBF file format when exporting table data from
> Postgresql. Does anyone know how to do this or have
> a utility for it?
>
> Bob Powell
> The Hotchiss School
>
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Reimer | 2002-04-15 17:29:31 | User-Defined Datatypes |
Previous Message | Dmitry Tkach | 2002-04-15 17:07:20 | Alter/update large tables - VERRRY annoying behaviour! |