Hi at all. 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 ? Anyone know where I can find manual/info about starbase? Tks in advance Paolo
On Sun, 2002-02-10 at 03:10, Dixie wrote:
Hi at all. 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 ? Anyone know where I can find manual/info about starbase?
Your first action should be to download the user manual from the Sun web site. http://www.sun.com/software/star/staroffice/5.2/index.html -- Rafael
-----Original Message----- From: Rafael E. Herrera [mailto:raffo@neuronet.pitt.edu] Your first action should be to download the user manual from the Sun web site. http://www.sun.com/software/star/staroffice/5.2/index.html
A manual would be great. I must be blind. I looked all over the page and drilled into a bunch of links and never spotted anywhere to download the manual. Just download the software and order printed manuals. To the original question, I started loading up the ODBC driver but ran into problems. I just run a SQL command from a script to select what I want and put it into a CSV file, then in StarOffice hook to the CSV file which is easy enough. I can give you more details if you want to try this route. Greg Engel
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 ?
participants (4)
-
Dixie
-
genge1
-
Kevin Donnelly
-
Rafael E. Herrera