>I have a website that collects files from clients and translates them into a format for our UNIX server. I was just handed an ods file for the first time today. I can open with Excel 2010, but VFP doesn't seem to have any knowledge of this file type, which makes sense due to it's age.
>
>Is there a third party add-on that will allow me to translate ods to a vfp cursor for processing? I don't think Office is installed and I've never tried automation of open office. Or is it time for a custom .NET dll call from VFP? I would love advice from anyone who's tried this so I don't go down a bunch of dead-ends.
>
>Thanks!

You might want to batch convert your .ods files before vfp looks at them:

PyODConverter:
http://www.oooninja.com/2008/02/batch-command-line-file-conversion-with.html

PyODConverter supports all of the formats that you can import or export manually in OpenOffice.org. They include:

* odt OpenDocument (ODF) Text
* sxw OpenOffice.org version 1 Text
* doc Microsoft Word 97/2000/XP
* rtf Rich Text Format
* txt Plain text
* wpd WordPerfect
* html Web page
* ods OpenDocument (ODF) Spreadsheet
* sxc OpenOffice.org version 1 Spreadsheet
* xls Microsoft Excel 97/2000/XP
* odp OpenDocument (ODF) Presentation
* sxi OpenOffice.org version 1 Presentation
* ppt Microsoft PowerPoint 97/2000/XP
* swf Adobe Flash

or jodconverter: http://www.artofsolving.com/opensource/jodconverter