By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,828 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,828 IT Pros & Developers. It's quick & easy.

MS Access(with special characters) -> MySQL

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Ruby Tuesday" <ru*********@yahoo.com> wrote in message
news:c5*************@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
Jul 17 '05 #2

P: n/a
I did export them to CSV text but the fraction(and other non-ascii)
characters still there? Helllllllllllllppp!
Jul 17 '05 #3

P: n/a
"Ruby Tuesdays" <No**********************@yahoo.com> wrote in message
news:c5*************@ID-205437.news.uni-berlin.de...
I did export them to CSV text but the fraction(and other non-ascii)
characters still there? Helllllllllllllppp!


Tried this? Access to MySQL converter.
http://www.phpbuilder.com/snippet/de...nippet&id=1019
(I haven't).

Garp
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.