Graywolf
Heres the full story.
We are running FMGo on an iPad.
The client travels with it and links back to to his Filemaker server to review daily sales etc using FMGo. This is all handled via a specific iPad designed layout - he clicks buttons and views reports in PDF preview.
Sometimes, at shows, (he sells high-end glasses), he likes to be able to produce on the fly reports for suppliers about sales in a particular period of time - so I provide him with Excel export from Filemaker.
This is, of course, not a Go feature. I can export the contents of a field, and I fill the field with data gathered into a variable as we loop through records. The data is all tab separated with valid line feeds, I stuff it into the body of an eMail and he copies the body then discards the eMail.
If he pastes into numbers we get the data in two forms: 1) all in one field or 2) in some find of floating object that I don't follow.
I am thinking that if I could get the data into a text file and save it somewhere (Dropbox, iDisk) he can pull that into Numbers and open it.
I can also export the field contents but all I get is txt files.
The goal would be to create a file that I can code Filemaker to open in the IOS and then pass to another iApp - and one of the choices to view in would be Numbers. Problem is is that Filemaker will export the contents of the field as .txt no matter what extension I try to force. Eg. I export field as "Data.numbers" but the IOS creates "Data.txt". So what I really need to figure out is a way to get a Numbers sensitive file out.