Hi, I would like to convert my Microsoft Access 2007 database files from my Windows PC into Apple Numbers on my 2016 15" MacBook Pro. If anyone has done this, could you please let me know what the best method is to do so? The files are .mdb and I would like to have the same or near the same functionality as I do in Access. I do not want to use Mac Parallels. Your help would be most appreciated if you have a workaround. Thank you. Ray
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Can Microsoft Access Files be Imported Into Numbers?
- Thread starter Ray&Paula
- Start date
- Sort by reaction score
No you cannot. You can export the database tables to .csv format in Access to use in Numbers but that won’t give you anything like the functionality you’d have in Access.
Numbers is a spreadsheet application, and MS Access is a database application. The two are not comparable.
Numbers is a spreadsheet application, and MS Access is a database application. The two are not comparable.
you can with filemaker - but it might be more than you want to invest to have a database app on MacOS
I just found a workaround that worked for me. All I had to do was go into Microsoft Access and export the file/s to an Excel format .xlsx
The following are the steps I took........ Hopefully this will help others with the same problem.
Connect an external hard drive, stick, etc. to your Windows PC
Open Access > Open a Database > Right mouse on file wanted > Export > Excel
A window will pop up asking you to specify a destination file name and format.
File Name: Browse/Choose a connected external hard drive, stick, etc.
File Format: Under the drop-down arrow choose; Excel Workbook (*.xlsx)
Specify export options:
Check – Export data with formatting and layout.
Click OK
Note: You can save these steps if wanted in a following window pop up.
Click Close
Eject/Disconnect external hard drive, stick, etc. and connect to your Mac
Open Numbers > File > New > Layout if wanted > File > External hard drive, stick, etc > Dbl click on your .xlsx file.
Your Access file will now open in Numbers.
I’m not sure of all the functionality yet, but you can access the rows and sort along with editing them.
The following are the steps I took........ Hopefully this will help others with the same problem.
Connect an external hard drive, stick, etc. to your Windows PC
Open Access > Open a Database > Right mouse on file wanted > Export > Excel
A window will pop up asking you to specify a destination file name and format.
File Name: Browse/Choose a connected external hard drive, stick, etc.
File Format: Under the drop-down arrow choose; Excel Workbook (*.xlsx)
Specify export options:
Check – Export data with formatting and layout.
Click OK
Note: You can save these steps if wanted in a following window pop up.
Click Close
Eject/Disconnect external hard drive, stick, etc. and connect to your Mac
Open Numbers > File > New > Layout if wanted > File > External hard drive, stick, etc > Dbl click on your .xlsx file.
Your Access file will now open in Numbers.
I’m not sure of all the functionality yet, but you can access the rows and sort along with editing them.
Last edited: