Exporting to Excel

[Kristi_n_VT]

I am using FM5 and want to export a data from repeating fields into Excel to create a simple timesheet report. The excel report will use data from other sources as well. I export the data as "tab-separated text" into Simple Text and then open the simple text file in excel. The data exports, but since I am exporting data from repeating fields, all the data for each repeating field is exported into one cell per repeating field. How can I correct this and is there a better way to do it? Thanks in advance to anyone who can assist!

[slbr549]

One way is to set up a clone filemaker db file (no records). Import the file that contains the repeating field from the original db into the Clone db. Select the option "Split repeating fields into separate records". Each repeating field will have it's own complete record. Then, export the data from the clone and import into Excel.

Hope this helps.