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. SQLyog (www.webyog.com) has a odbc import tool for for this (not free though). hth Rik