| From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Moving data from M$ JetDB file to Postgres on Linux |
| Date: | 2014-03-01 11:33:58 |
| Message-ID: | 20140301123358.79bffa9c1c8e5c4d6743cf5d@wanadoo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 28 Feb 2014 16:03:39 -0800 (PST)
Rich Shepard <rshepard(at)appl-ecosys(dot)com> 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 on older version of Jet database files and small files. I've haven't tested it on Access 2007+.
I understand you run linux, but if you can get hold of a Windows machine with Access on it, or find someone who does, you can always export to text and use that. You can use recent versions of the software to open older files usually.
Perl's DBI.pm is also handy to extract data, on a Windows machine with the proper drivers.
--
http://libremen.com
Gestión de litigios y de expedientes de seguros de siniestros para el servicio jurídico
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2014-03-01 14:03:31 | Re: Moving data from M$ JetDB file to Postgres on Linux |
| Previous Message | Michael Paquier | 2014-03-01 09:53:38 | Re: pgrestore command |