Re: [mdb-dev] Import MDB to MySQL

[Jim S. <js...@jp...>]

At 10/29/2003 08:38 PM, Jurgen at Marketcom wrote:

>Hi,
>
>Has anyone already solved this problem? I'm looking to simply scoop all
>the data from an MDB file and dump it into a MySQL database (or
>whatever SQL, really, I just want to get this stuff into a real
>database so I can do something useful with it :-) ).

I haven't been successful yet in a RH 7.3 environment. I'm trying to do the 
same thing (MDB -> MySQL via Perl). I have data in the MDB format that has 
been exported from Microsoft Project. Unfortunately every table and field 
contains underscores. Because it's an export from another commercial 
program I have no control over the object names.

I can read the simplest MDB's I've created (without underscores) for 
testing but get segmentation faults on the real data. Putting single or 
double quotes around the table and field names as previously suggested 
doesn't help.

I'm running version 0.5. My SA is trying to build with the available 
patches and from CVS but is having problems. Getting MDB Tools running 
would be a lifesaver for me (I wouldn't have to run a Windows 2K server 
anymore).

Jim