My pet peeve about FileMaker (or perhaps with Excel) is that there is no
way to export data without losing the field names when re-importing in
to Excel.  

The best solution I've found is to export as DBF format, which Excel can
read and will keep field names, but it's not perfect:  DBF limits field
names to 10 characters and makes them all UPPER CASE.

Is there any other way to export to Excel without losing field names?
I've done the trick of making a dummy header record that contains field
names with built-in tabs, but that is not so elegant...

DIF should work (the field names are in the file), but Excel ignores
them.


-- 
To send email, remove the invalid and nospams.

"Mike D" <md03NOSPAM@xochiNOSPAM.com.invalid> wrote in message
news:1g58nbu.1mp4srs6k27ecN%md03NOSPAM@xochiNOSPAM.com.invalid...
> My pet peeve about FileMaker (or perhaps with Excel) is that there is no
> way to export data without losing the field names when re-importing in
> to Excel.
>

I have always found mer format to be the best for this. (Though you have to
open the merge file from within Excel as Excel does not recognise the
delimiters automatically)

Have you tried using DTS to do the export? It keeps the field names,
especially when the destination is SQL Server.



"Mike D" <md03NOSPAM@xochiNOSPAM.com.invalid> wrote in message
news:1g58nbu.1mp4srs6k27ecN%md03NOSPAM@xochiNOSPAM.com.invalid...
> My pet peeve about FileMaker (or perhaps with Excel) is that there is no
> way to export data without losing the field names when re-importing in
> to Excel.
>
> The best solution I've found is to export as DBF format, which Excel can
> read and will keep field names, but it's not perfect:  DBF limits field
> names to 10 characters and makes them all UPPER CASE.
>
> Is there any other way to export to Excel without losing field names?
> I've done the trick of making a dummy header record that contains field
> names with built-in tabs, but that is not so elegant...
>
> DIF should work (the field names are in the file), but Excel ignores
> them.
>
>
> -- 
> To send email, remove the invalid and nospams.

I think you have a nice possibility to use XML stylesheet to export
data to Excel without losing column headers. There is some examples

http://www.filemaker.com/xml/xslt_library.html

Regards

Mara

md03NOSPAM@xochiNOSPAM.com.invalid (Mike D) wrote in message news:<1g58nbu.1mp4srs6k27ecN%md03NOSPAM@xochiNOSPAM.com.invalid>...
> My pet peeve about FileMaker (or perhaps with Excel) is that there is no
> way to export data without losing the field names when re-importing in
> to Excel.  
> 
> The best solution I've found is to export as DBF format, which Excel can
> read and will keep field names, but it's not perfect:  DBF limits field
> names to 10 characters and makes them all UPPER CASE.
> 
> Is there any other way to export to Excel without losing field names?
> I've done the trick of making a dummy header record that contains field
> names with built-in tabs, but that is not so elegant...
> 
> DIF should work (the field names are in the file), but Excel ignores
> them.

Paul Robinson (mobile) <roro@telusplanet.net> wrote:

> Have you tried using DTS to do the export? It keeps the field names,
> especially when the destination is SQL Server.
> 
> 
> 

What is DTS?  

I'm doing the export from a Mac (FM 6), and the choices are:
   Tab Delimited Text
   Comma Delimited Text
   SYLK
   DBF
   DIF
   WKS
   BASIC
   Merge
   HTML Table
   FileMaker Pro
   XML

The import may happen on either Mac or Windows Excel... I suppose I need
to try both to be sure.


> "Mike D" <md03NOSPAM@xochiNOSPAM.com.invalid> wrote in message
> news:1g58nbu.1mp4srs6k27ecN%md03NOSPAM@xochiNOSPAM.com.invalid...
> > My pet peeve about FileMaker (or perhaps with Excel) is that there is no
> > way to export data without losing the field names when re-importing in
> > to Excel.
> >
> > The best solution I've found is to export as DBF format, which Excel can
> > read and will keep field names, but it's not perfect:  DBF limits field
> > names to 10 characters and makes them all UPPER CASE.
> >
> > Is there any other way to export to Excel without losing field names?
> > I've done the trick of making a dummy header record that contains field
> > names with built-in tabs, but that is not so elegant...
> >
> > DIF should work (the field names are in the file), but Excel ignores
> > them.
> >
> >
> > -- 
> > To send email, remove the invalid and nospams.


-- 
To send email, remove the invalid and nospams.

I like HTML Table because it includes field names and you won't have to 
go through Excel's conversion dialog to open it.

Mike D wrote:

> Paul Robinson (mobile) <roro@telusplanet.net> wrote:
> 
> 
>>Have you tried using DTS to do the export? It keeps the field names,
>>especially when the destination is SQL Server.
>>
>>
>>
> 
> 
> What is DTS?  
> 
> I'm doing the export from a Mac (FM 6), and the choices are:
>    Tab Delimited Text
>    Comma Delimited Text
>    SYLK
>    DBF
>    DIF
>    WKS
>    BASIC
>    Merge
>    HTML Table
>    FileMaker Pro
>    XML
> 
> The import may happen on either Mac or Windows Excel... I suppose I need
> to try both to be sure.
> 
> 
> 
>>"Mike D" <md03NOSPAM@xochiNOSPAM.com.invalid> wrote in message
>>news:1g58nbu.1mp4srs6k27ecN%md03NOSPAM@xochiNOSPAM.com.invalid...
>>
>>>My pet peeve about FileMaker (or perhaps with Excel) is that there is no
>>>way to export data without losing the field names when re-importing in
>>>to Excel.
>>>
>>>The best solution I've found is to export as DBF format, which Excel can
>>>read and will keep field names, but it's not perfect:  DBF limits field
>>>names to 10 characters and makes them all UPPER CASE.
>>>
>>>Is there any other way to export to Excel without losing field names?
>>>I've done the trick of making a dummy header record that contains field
>>>names with built-in tabs, but that is not so elegant...
>>>
>>>DIF should work (the field names are in the file), but Excel ignores
>>>them.
>>>
>>>
>>>-- 
>>>To send email, remove the invalid and nospams.
> 
> 
> 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance

Oops, my mistake.

I assumed you're on Wintel. DTS is a tool that comes with Microsoft SQl
Server.



"Mike D" <md03NOSPAM@xochiNOSPAM.com.invalid> wrote in message
news:1g59ahf.1rbpwiw1rqtybkN%md03NOSPAM@xochiNOSPAM.com.invalid...
> Paul Robinson (mobile) <roro@telusplanet.net> wrote:
>
> > Have you tried using DTS to do the export? It keeps the field names,
> > especially when the destination is SQL Server.
> >
> >
> >
>
> What is DTS?
>
> I'm doing the export from a Mac (FM 6), and the choices are:
>    Tab Delimited Text
>    Comma Delimited Text
>    SYLK
>    DBF
>    DIF
>    WKS
>    BASIC
>    Merge
>    HTML Table
>    FileMaker Pro
>    XML
>
> The import may happen on either Mac or Windows Excel... I suppose I need
> to try both to be sure.
>
>
> > "Mike D" <md03NOSPAM@xochiNOSPAM.com.invalid> wrote in message
> > news:1g58nbu.1mp4srs6k27ecN%md03NOSPAM@xochiNOSPAM.com.invalid...
> > > My pet peeve about FileMaker (or perhaps with Excel) is that there is
no
> > > way to export data without losing the field names when re-importing in
> > > to Excel.
> > >
> > > The best solution I've found is to export as DBF format, which Excel
can
> > > read and will keep field names, but it's not perfect:  DBF limits
field
> > > names to 10 characters and makes them all UPPER CASE.
> > >
> > > Is there any other way to export to Excel without losing field names?
> > > I've done the trick of making a dummy header record that contains
field
> > > names with built-in tabs, but that is not so elegant...
> > >
> > > DIF should work (the field names are in the file), but Excel ignores
> > > them.
> > >
> > >
> > > -- 
> > > To send email, remove the invalid and nospams.
>
>
> -- 
> To send email, remove the invalid and nospams.

Mike D <md03NOSPAM@xochiNOSPAM.com.invalid> wrote:

> DIF should work (the field names are in the file), but Excel ignores
> them.

appleworks... works
-- 
Philippe Manet