From: "David Blomstrom" <[EMAIL PROTECTED]> > --- Chris W <[EMAIL PROTECTED]> wrote: > > If you plan on using this process again, you may > > want to track down the > > source of the problem, but if you aren't going to
The "source of the problem" is the fact that it is common in a CSV file to represent a quote inside quoted data by doubling it. The MySQL import gives you the option to define an escape character, but in this case adding an ESCAPED BY '"' doesn't really help at all. > > be exporting this way > > again and you just want to fix it, I would just open > > the csv file in a > > text editor and do a search and replace. > > That's a good question. I'd like to export as little > as possible, but I'll probably be making constant > changers to my database. That means I'll have have to > modify my spreadsheet (my master record), then save it > as a csv file, then import it into my database. You can solve it by either doing a search and replace in the CSV or performing an update query that replaces "" by " in MySQL. > I finally broke down and purchased Navicat, which can > apparently export from Excel to MySQL. However, I > don't have Excel; I have Microsoft Works. And I hate > to buy Excel when I'm planning on getting StarOffice - > but will StarOffice work with Navicat and MySQL? StarOffice and OpenOffice.org (the Open Source version of StarOffice) both have the option to communicate with MySQL built in (plus the option to access any database by using ODBC)! It's a bit hidden inside the program, but there is a database front end in StarOffice(SO)/OpenOffice.org(OOo) that resembles MS Access, so you can directly manipulate MySQL records from SO/OOo. You might want to consider getting OpenOffice.org (which is free) since you don't need the database that's included in SO (you'll be using MySQL) and you may manage to do without the third party stuff (import/export filters, etc.) which are not included in OOo. If you want more info on OOo working with MySQL you can join one of the many e-mail lists (there's probably one in your own language) (see http://www.openoffice.org/mail_list.html and e.g. http://da.openoffice.org/servlets/ProjectMailingListList for the Danish mailing lists, etc.). There are many people on such a list to help you on your way and they can probably provide you with tutorials, etc. I think that you'll find that it is possible for programs to co-operate, especially when both are OpenSource ;-) Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
