Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Exporting report RESULTS to .txt or Excel

Featured Replies

  • Newbies

Sorry this is such an idiot question, but I'm a beginner and cannot find in the manuals how I export the RESULTS of a layout that has exactly the information I need. I can see it on screen and print it out, but I don't know how to get it into a format I can read in Excel.

I can export the entire database, but I want to export ONLY the results shown in my format that I can see on-screen.

I'm using FMP 6.0 under OSX 10.4.7 on a Mac G4.

Thanks!

Dave

I had the same problem with FM7. The only way I found to get my summary data into excel was to publish to PDF and use the copy table function (Acrobat Pro or Standard versions only) to copy the text into Excel. This was a Major pain! Not only could you not do this with the standard version of Acrobat Reader, but I could only do one page at a time. FM8 has built in functionality to export to Excel, which is the sole reason I upgraded.

I hope for your sake that there is an easier solution in FM6, but I was never able to find one during my searches.

P.S. I'm using OSX as well.

Edited by Guest

According to the Online Help, v6 can import and export in SYLK format. I have not used this format, but it says that it works with most spreadsheets.

HTH

Lee

BTW, I usually use the a text format.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.