Re: From MySql to ACCESS

On Wed, Jul 19, 2006 at 06:37:53PM +0200, Michele Monaco wrote:
> I have a MySql database, I need to convert in an Access format.
> 
> May MdbTools help me?

In my opinion, mdbtools is not the tool to use for this.
mdb-sql might be able to do it (I haven't ever used mdb-sql) but
the write support of mdbtools is much younger than the read
support.

Rather do something like this:

  Use MS Access as a front-end to MySQL by linking tables.

or:

  Dump the schema and data from MySQL using the mysqldump
  command, edit the dump file to fix the "CREATE TABLE" commands
  etc., so that Access will accept them.  Then execute the SQL
  statements in Access.

or:

  Figure out how to get the data exported from each table in CSV
  format, create all the necessary tables within Access and then
  import each table's data.

P.S. I am no expert in either MySQL or MS Access...

-- 
Michael Wood <[email protected]>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV