Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

I think that PHP has modules (eg, PEAR) that can read MS Access database files, and once you have it in an array you can create INSERT statements for PostgreSQL, including cleaning up any data format issues (eg, dates of 00-00-) -- Mike Nolan On Fri, Feb 28, 2014 at 6:21 PM, Rich Shepard wrot

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

FYI, Pretty sure Apache Office Base has native support to open Access.mdb files on a linux box -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Sat, 1 Mar 2014, Adrian Klaver wrote: FYI in the Summary / Abstract at the above link there is this: "If you would like these data in a different format or would like help in using this file, please contact.." I missed seeing that. Thanks. Rich -- Sent via pgsql-general mailing lis

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On 03/01/2014 06:41 AM, Rich Shepard wrote: On Fri, 28 Feb 2014, John McKown wrote: Is this data generally available? If so, then can you tell us how to get a copy of the data? If we can get a copy, it might be able to figure out how to read it. John, Here's the URL:

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Fri, 28 Feb 2014, John McKown wrote: Is this data generally available? If so, then can you tell us how to get a copy of the data? If we can get a copy, it might be able to figure out how to read it. John, Here's the URL: R

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Sat, 1 Mar 2014, Vincent Veyron wrote: I've had success with mdbtools, but on older version of Jet database files and small files. I've haven't tested it on Access 2007+. Vincent, I suspect this file is in the current Access version. I understand you run linux, but if you can get hold

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Fri, 28 Feb 2014 16:03:39 -0800 (PST) Rich Shepard wrote: > > And, I discovered 'jet-tool' on code.google.com. That'll do the job, I > > believe. > >Well, it won't work: it's a M$ .exe file and the source is apparently in > some M$-type of Pascal. > I've had success with mdbtools, but

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On 02/28/2014 04:34 PM, Rich Shepard wrote: On Fri, 28 Feb 2014, Adrian Klaver wrote: Well JET is the database engine for Access and mdb is one of the file format extensions for Access database files. JET has been used in other MS products and Access has used different file formats(extensions)

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On 02/28/2014 04:10 PM, Thomas Kellerer wrote: Rich Shepard wrote on 01.03.2014 00:21: I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anyt

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Sat, 1 Mar 2014, Ian Lawrence Barwick wrote: Not sure if this will be of use, but there are a couple of links here: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access I'll post it anyway in case someone comes across this thread in the future.

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Sat, 1 Mar 2014, Thomas Kellerer wrote: No, not within psql, but from within a Java/JDBC based query tool (such as my SQL Workbench) Oh. OK. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Fri, 28 Feb 2014, Adrian Klaver wrote: Well JET is the database engine for Access and mdb is one of the file format extensions for Access database files. JET has been used in other MS products and Access has used different file formats(extensions) over the years. So you may be in for a chore

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 9:34 GMT+09:00 Rich Shepard : > On Fri, 28 Feb 2014, Adrian Klaver wrote: > >> Well JET is the database engine for Access and mdb is one of the file >> format extensions for Access database files. JET has been used in other MS >> products and Access has used different file formats(extens

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

Rich Shepard wrote on 01.03.2014 01:33: On Sat, 1 Mar 2014, Thomas Kellerer wrote: It's not clear to me what exactly you are trying to do. Or are you just trying to copy the data into the Postgres database? If the latter you could try one of the JDBC based query tools to export or copy the d

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Fri, 28 Feb 2014, Adrian Klaver wrote: Well JET is the database engine for Access and mdb is one of the file format extensions for Access database files. JET has been used in other MS products and Access has used different file formats(extensions) over the years. So you may be in for a chore

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Sat, 1 Mar 2014, Thomas Kellerer wrote: It's not clear to me what exactly you are trying to do. Or are you just trying to copy the data into the Postgres database? If the latter you could try one of the JDBC based query tools to export or copy the data using the UCanAccess JDBC driver for

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

Rich Shepard wrote on 01.03.2014 00:21: I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anything useful; the closest was a thread from this

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On 02/28/2014 03:58 PM, Rich Shepard wrote: On Fri, 28 Feb 2014, Adrian Klaver wrote: The only software I could find to directly read MDB files on Linux is : http://mdbtools.sourceforge.net/ Not sure what version of MDB you have and whether the above is current enough to read them. Otherwise yo

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Fri, 28 Feb 2014, Rich Shepard wrote: And, I discovered 'jet-tool' on code.google.com. That'll do the job, I believe. Well, it won't work: it's a M$ .exe file and the source is apparently in some M$-type of Pascal. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On Fri, 28 Feb 2014, Adrian Klaver wrote: The only software I could find to directly read MDB files on Linux is : http://mdbtools.sourceforge.net/ Not sure what version of MDB you have and whether the above is current enough to read them. Otherwise you need to crank up an Access instance and go

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

On 02/28/2014 03:21 PM, Rich Shepard wrote: I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anything useful; the closest was a thread from t

[GENERAL] Moving data from M$ JetDB file to Postgres on Linux

I just downloaded two scientific data files from a federal agency's Web site. Both are in M$ JetDB format. I run only linux and keep all my scientific dat in postgres. My Web search did not turn up anything useful; the closest was a thread from this mail list in 2000 on how to send a postgres