Newbies Kristi_n_VT Posted May 21, 2001 Newbies Share Posted May 21, 2001 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! Link to comment Share on other sites More sharing options...
slbr549 Posted May 21, 2001 Share Posted May 21, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8368 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now