exporting field names to excel ARRghhhh

[blitzwing]

Hello all, I am a student, and I have exported Filemaker Pro data to excel in sylk format, which I am told is the best for excel, but it has not given me any field names.

I have a zillion fields and do not want to type them up in excel.

I tried a merge format (but apparently this is for word, not excel) and this gave me fields but there were

" " everywhere. And all the data was in one huge cell.

Any help would be greatly appreciated. I do not know why filemaker has not given any clear support (as in documentation) in regard to this.

I am ok with computers but this 'simple' task is completely beyond me

Edited August 15, 2005 by Guest

[Lee Smith]

There are a couple of different Export Formats that have the field names. Merge, and HTML come to mind. For more on this, open up FileMaker, click on the Help (Cmd ?) and look up File Formats.

HTH

Lee

[blitzwing]

hi lee, thx for your interest

ok htlm worked.

Merge - there are " " "" " "" " " everywhere. Can i make them seperate cells again?

If html is ok ill use it, but i was told slky is the absulute best for excel, and that html and merge should only be used with microsoft word. Why was i told that. Whats wrong with html anyway; is it unreliable with excel or soemthing. I mean it looks ok in excel. Seems to be all there.

Edited August 15, 2005 by Guest

[comment]

AFAIK, merge should work fine - provided you tell Ecel you're importing a comma separated values file.

[Lee Smith]

Actually you can open it directly in Excel, and follow the menus. One of the Menu lets you choose a file delimiter, be sure you choose comma.

Lee