5 Replies Latest reply on Nov 13, 2012 5:55 AM by Sorbsbuster

    export to MS Word

    Fagreement

      Title

      export to MS Word

      Post


           how to export records to MS word. it is not proposed in the list of file type in FM.

        • 2. Re: export to MS Word
          Fagreement

               sorry but your post doesn't help me, still need to do export from a list in FM to word, how?

          • 3. Re: export to MS Word
            philmodjunk

                 You can import to merge, tab, text or even csv and then open the file in MS Word. Merge files are an old file format specifically designed so that you can use MS Word with them to produce "form letter" type output where the values exported from fileMaker are inserted into text created in MS Word.

                 If that doesn't work for you, please indicate what you need in more detail.

            • 4. Re: export to MS Word
              alc

                   Fagreement:

                   The short answer to your question is that FMP does not directly export to Word. (neither .rtf* or any or any of the .doc formats) although it does export to merge format needed for mail merges - it would only be a decent alternative if you didn't have to waste time playing with wizards when all you want is the data (BLECH!) )

                    

                   So as Phil suggested you have several options (all of which are naturally 'table type' formats.

              tab/text: this just exports data as tab-delim text (fields seperated by tabs). You can easily open this in Word, then convert to table, format, whatever.

                   The downside is that FM doesn't include an option to include field names (which is enormoursly confusing if you have any 'boolean' fields like 1 for yes or otherwise unidentifiable fields.)

              cvs: (same as above but seperated with commas - the only time to use this is for apps that don't except anything else, so I ignore)

              Excel (.xlsx): Although this means you have an extra step (namely moving data from excel to Word). I prefer it for following reasons:

                     
              1.           You have a permanent snapshot of the data (effectively a data backup)
              2.      
              3.           You can massage data and data display - more easily than word in certain cases - Notably: you'll find repetitive info in fields from parent tables since FMP exports data as Flat table.
              4.      
              5.           You can easily created subsets of data using Excel's filters.
              6.      
              7.           Unlike text formats: you have the field names (so you have a clue what the data means) and can use the file for export back to FMP if ever needed.
              8.      
              9.           Excel generally correctly interprets field types (number, text  etc) Though you need to be somewhat cautious with dates.

                   The only real downside to Excel format is that there's no official export to Word function, you're reduced to copy/paste - which can be painful with large databases (this is where filters can be helpful ).

                    

                   *COMMENT:

                   It's REALLY sad that FM does not export .rtf ( or .doc format) : Imagine how nice it would be to export a report (or layout with subsummarys - (ideally maitaining basic formatting - like bold text) to Word which provides much more sophisticated formatting, and most importantly allows user to massage things like page breaks, inconsistent data etc.

                   Hope this helps - xandra

                    

              • 5. Re: export to MS Word
                Sorbsbuster

                     "The downside is that FM doesn't include an option to include field names" - merge format does that, as does the Excel export.  I'd be more enthusiastic for a direct export to Word if I didn't find Word the most convoluted, inconsistent, maddening application.