There may be cooler ways of doing it, but I use the following: 1) (in console) mysqldump -uusername -p dbtodump [tabletodump] > dumpfile.csv (the tablename is optional - use it if you want to dump specified tables from the db) 2) Open dumpfile.csv in SO - it will try to load it into a spreadsheet and ask you about the structure. Untick Comma, and tick Other, and put ' (single quote) in the box. This will open the dump file with all the sql stuff in separate columns - you can then delete the columns you don't want. 3) Do a Save as on the revised csv file, and tick the Edit Filter box. You can then choose the delimiter (eg comma instead of tab), etc. You can do this by running mysqldump with various option, eg terminated-by, delimited-by, etc, but I'm too lazy to do that every time - the above means you have a file you can fiddle about with in SO, which is faster, and you still have the original dumpfile if you need to start from scratch. phpMyAdmin also has a range of options for doing a dump, so if your hoster has the latest version installed that might be preferable to mysqldump. HTH Kevin On Sunday 10 February 2002 08:10, Dixie wrote:
My goal is insert into a StarOffice text file data from a database (such as MySQL and/or MS Access). I suppouse that's possible with ODBC but I don't know how can I do it. Any suggestion ?