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.

Clean Excel export

bbaliner
in Importing & Exporting

Featured Replies

Hi folks,

Does anyone know of a good way to export directly into excel, whithout going thorough an intermediary app like .dbf or .tab file? Maybe a plug-in or something?

That'd be great not to have the headings butchered. I wonder when (or if) FM will convince Microsoft to honor FM export directly...

Presumably ODBC is not working for you...

You could automate the export to the TAB/CSV file, and then set this is up as a data source in Windows, so that Excel could automatically update a worksheet from this data

  • Author

--Presumably ODBC is not working for you...

Wait, are you talking about using ODBC between Excel and File Maker? I haven't tried that, I assumed ODBC is only for SQL databases interface.

--You could automate the export to the TAB/CSV file, and then set this is up as a data source in Windows, so that Excel could automatically update a worksheet from this data

I can do the first part. In the second part are you suggesting writing a macro for excel automatic update from data source?

Thanks for your advice.

BB

Create an account or sign in to comment

https://fmforums.com/topic/10240-clean-excel-export/
Go to topic listing

Important Information

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

I accept

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.