Re: Export to Excel without losing field names

Oops, my mistake.

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



"Mike D" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Paul Robinson (mobile) <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > 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.