I want XML in general, but unfortunately, it is not that simple with .ods files. How do you extract and what will you get in the XML? I know in Windows with .sxc files you do not get simple XML data, you get XML data with unwanted attributes. This is one of a number of areas in which OpenOffice fails to match Office Professional, and why organizations like mine will not switch to OO in a professional setting. OO is a viable alternative to standard Office, but OO Base does not match Access on the professional level.
At home I can get by with this by running my databases in MySQL which has a simple XML export function. In OO I simply connect to the MySQL data base. -----Original Message----- From: CPHennessy [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 5:50 PM To: [email protected] Subject: Re: [users] Export data to XML file On Mon August 28 2006 20:52, Schultz, Gary - COMM wrote: > Is there an easy way to export data from a calc spreadsheet or base > table/query to XML data? I have to say this is one of the nice things > about MS Access, it is extremely easy to export Access tables and > queries to simple XML data files. I just don't see a feature this easy > to use in OO Base. Problem I'm having, is that MS Access keeps > crashing and is almost useless. So, I really need a base table/query > to xml data feature. Any suggestions? Do you already have a predefined XML format or you just want XML in general ? If it is the later then you can unzip the .ODS file and use the content.xml file. if it is the later then you need to write some XSLT ( have a look on http://xml.openoffice.org for more detail). -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
