Jump to content

Exporting to Excel


Kristi_n_VT
 Share

This topic is 7457 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

This topic is 7457 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.