From: Garp <garp7@...7.blueyonder.co.uk>
Date: 2004-04-10T06:29:17+09:00
Subject: Re: MS Access(with special characters) -> MySQL


"Ruby Tuesday" <rubytuzdayz@yahoo.com> wrote in message
news:c570m3$2p301g$1@ID-205437.news.uni-berlin.de...
> How do I transfer my MS Access DB to MySQL?
>
> One issue though, in Access I have some special character such fraction,
> backquote, etc ...
>
> how do I replace those characters to ASCI equivalent when transfering to
> MySQL, or do I have to do it outside MySQL? Thanks

The usual thing is to export to a non-proprietary format (CSV is handy) and
then import it to your target. phpMyAdmin is very good at importing CSV.
Hopefully the characters you're worried about will survive the export, MS
Access isn't that poor.

Btw, kudos on moving it to MySQL!

Garp