Check out http://www.dbtools.com.br/EN/ I use it to import from access to mysql. By the sounds of it though you have some dirty data which may or may not need to be cleaned before going through there program. The only real problem I had was that working with old dirty data is a pain since a lot of the columns have spaces in there names (which mysql doesnt like) and the access isn't as strict as MySQL with what can be put into certain fields.
-Nick Ian Zabel said: > I already have my table structure in place in MySQL, and I just want to > import the data from my Access 2000 database. (the .mdb is about 50 > megs) > > The MySQL server is on a Linux system. > > I've been using DBTools to do the import, because it allows me to import > just the data, and not create the tables. (I don't want it to create the > tables, because it's creates them inccorectly. I used another tool to > create the schema, and and fixed all the problems with it.) > > My problem is that when the import is done, all my varchar (text in > access) and text (memo in access) field data leaves behind escape > switches. All quotes look like this \' or \" and all linefeeds look like > this \r\n. I also have other weird characters in the data. > > If I export the data using MySQL-Front, I get stuff like this: \\\" \\\' > \\r\\n > > > Also, some of my data has special characters like the ellipses characer, > ., and when I view access the data through my code, it comes out like > this ?. > > What is the best way to import data to a MySQL server on Linux and > preserve the correct escaping? > > Ian. > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
