[Zope] Importing Microsoft Access into ZODB

[John Poltorak]

On Thu, Feb 24, 2005 at 12:45:00PM +0100, Rik Hoekstra wrote:
> John Poltorak schreef op 24-2-2005 11:23:
> 
> > On Thu, Feb 24, 2005 at 10:17:30AM +0000, Chris Withers wrote:
> > 
> >>John Poltorak wrote:
> >>
> >>
> >>>Are there any tools for importing an Access file into Zope on Unix.
> >>
> >>I would suggest importing it into another RDB and using that RDB from 
> >>Zope via ZSQL Methods. There's no point to put relational data into ZODB...
> > 
> > 
> > Is there an easy way of importing an access file into any other RDB, and 
> > if so which one? I've looked at various options and they all look fairly 
> > tortuous if you don't already have the requisite software installed.
> >  
> 
> You could use any rdb, we use mysql. There are many tools and tutorials 
> to convert an access db to mysql, we have done this many times. For a 
> tutorial see
> http://www.kitebird.com/articles/access-migrate.html, including links to 
> software to automate this. 

I looked at this but it appeared as though I needed to have Microsoft 
Access installed, but I don't have it available.


> hth
> 
> Rik


-- 
John