Lee, as CSV, is this to be opened in Excel? And if so, in what version
of Excel? FMP & SQL require the same number of columns in each row to
open a csv file. Excel, just reads the data until a return/new line is
encountered, AFAIK.
Excel will also read XML in a format that places data in particular
cells, if that's what you need. Export from FMP as XML and apply an
XSLT to make an .xlsx file.
--
Beverly Voth
mailto:[email protected]
tel:(606) 258-7399
--
On Jul 8, 2009, at 1:34 AM, Lee <[email protected]> wrote:
Hi,
I can export data to csv, no problem however can you create a header
and a footer with other data as a csv file.
For example you can have 20 lines of data with the top line
displaying information from 3 other fields and a Footer with totals
etc.
Lee Mills
--