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.

migrating from MS Access to FMP 8

Featured Replies

  • Newbies

Hi All,

Has anyone migrated off MS Access onto FMPro 7 or 8 ?

Is there a simple way, or a tool I should know about ?

The dbase isn't that complicated, but it has quite a few records (10k +) in each of 3 tables.

Any help would be great.

Thanks,

Ted

You can import the tables into filemaker with fieldnames intact if you export from access to something like excel or merge files that preserve field names.

What you won't be able to do is convert any expressions to calculations, or vba scripts to scriptmaker scripts. They will have to be recreated manually as will all of your relationships between tables and any forms you created in access.

I migrated from Approach several months ago. Many thousands of records. I exported each table into excel and then imported into FM. It handled the mapping very well. Suggest you use the same or similar field names it will save you a lot of time mapping your fields. I created my tables and layouts in FM first then imported.

Have fun. I tried to go with Access before FM. You should enjoy the transition.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.