On 26/02/2012, at 7:00 PM, Chris Burton wrote: > Good afternoon muggers > > I have received an xml file from a collegue of mine (a result of an export > from a database) and I cant open it with the applications that show up when > 'open with' is applied. > > Can someone please point me in the direction of an application and/or utility > that I can use to open it? > > Thanks very much for any advice on this > > Best regards > > Chris > >
Since you know that the xml file has come from a database, this gives us a pretty good insight int show the xml file will be structured, and it should show meaningful data when imported int any modern version of M$ Excel. Failing that, try opening it with Filemaker Pro (if you don't have a copy, a fully-functional 30-day trial can be downloaded from http://www.filemaker.com.au). Filemaker will convert the xml file to a native Filemaker Pro database, giving you all the organisational power you need to analyse the data, or you can export the data back out to an xlsx file, which WILL work with Excel 2011 or Numbers, or you can export to a tab-or comma-delimited text file for use in myriad other list managers. You'll probably want to do these things anyway, since your Filemaker Trial will stop working after 30 days... Peter Hinchliffe Apwin Computer Services FileMaker Pro Solutions Developer Perth, Western Australia Phone (618) 9332 6482 Mob 0403 046 948 -------------------------------------------------------------------- Mac because I prefer it -- Windows because I have to. -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Settings & Unsubscribe - <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug>
