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.

Importin Microsoft Access MDB files

jess
in Importing & Exporting

Featured Replies

I've read that Filemaker does not support this file type and I should re-export my MDB file to something more FM friendly. However, I don't own a copy of MS-Access, so I can't re-export my file.

Any ideas on how to convert a MDB file without owning a copy of MS-Access?

thanx...

I believe you can open an mdb file in excel.

File>Open>C:/Program Files/msoffice/Access/Northwind.mdb (Or whatever it may be)

Make sure you check Open MDB file.

A list of tables will open, check off the table you want and it will bring it into Excel. Save as an excel file and you can now import into FM.

HTH

  • Author

Unfortunately, the Access database file has about 1.5 million records. MS-Excel tops out at 65,000.

Download the Microsoft Office 2007 Beta. With MS Access open the database table with your 1.5 million records and export TAB delimited.

This text can be imported in FileMaker.

Happy FileMaking Ralph Nusser

Create an account or sign in to comment

https://fmforums.com/topic/47181-importin-microsoft-access-mdb-files/
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.