I don't think that's going to work because it sounds like the escapes are built into the data. The only thing I can think of is to run it through a function first to strip out said escape characters, and then import it. PHP has a stripslashes() function that does that, and you certainly could write a quick script that will output your access table as a comma-delimited file that way (or, I guess, insert it directly into a MySQL database). Course, that might not help a lot. There might be a VB equivalent, and you could run that against your MEMO fields as an update query in Access, and then export to MySQL from there.
Hope that helps... > -----Original Message----- > From: nick gatsis [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 12, 2002 1:42 PM > To: [EMAIL PROTECTED] > Subject: Fwd: Re: Importing into MySQL from Access > > > Did you try to make an .csv file and then import it > with Mysql-Front? > I believe that both tables have the same structure. > > > > > --- Ian Zabel <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > 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 > > > > > > > > ____________________________________________________________ > > Do You Yahoo!? > > &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; > > http://www.otenet.gr > > > > ____________________________________________________________ > Do You Yahoo!? > &Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr > > --------------------------------------------------------------------- > 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