On 08/22/2012 05:41 PM, Mike Christensen wrote:
On Wed, Aug 22, 2012 at 5:38 PM, Mike Christensen <mike@xxxxxxxxxxxxx> wrote:
On Wed, Aug 22, 2012 at 5:34 PM, Bosco Rama <postgres@xxxxxxxxxxxxx> wrote:
On 08/22/12 17:23, Mike Christensen wrote:
I'd like to import this data into a Postgres database:
http://www.ars.usda.gov/SP2UserFiles/Place/12354500/Data/SR24/dnload/sr24.zip
However, I'm not quite sure what format this is. It's definitely not
CSV. Here's an example of a few rows:
~01001~^~0100~^~Butter, salted~^~BUTTER,WITH
SALT~^~~^~~^~Y~^~~^0^~~^6.38^4.27^8.79^3.87
<http://www.ars.usda.gov/SP2UserFiles/Place/12354500/Data/SR24/sr24_doc.pdf>
Section "Relation Files" (Logical page 25)
Okay so is there a way to import "Relational Files" into Postgres?
The alternative would be to download the Excel version, then Save as
CSV, and import into Postgres via the COPY command.
Oh, also if anyone knows of a way to export an Access database to
Postgres, that might be helpful. I don't have a copy of Access.
There is MDB tools. It is only works with older versions of Access and
is limited in what it can do:
http://mdbtools.sourceforge.net/
Do you have a Windows machine available? Depending on what is installed
there may be an Access ODBC driver available that will allow you jump
through an intermediate step i.e. Excel.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
