

If a field in the first valid data row contains a number, the whole column is set to number format, and only numbers, no text, will be shown in that column. Expect delays redesigning for Access functionality, or missing feature set.For example, to ensure the first column has a text format, you must make sure that the first field of the first valid data row contains text. I omitted LibreOffice owing to administrative overhead, and complexity of requiring Java for Base database operations, and the negative of taking a proprietary database into another proprietary database. Options 4 and 5 allow one to quickly jump start the MS Access 2016 database usage on Mac without data conversion expense, delays, or measurable administrative overhead.

Access from Windows, Mac, iOS, or Android.


This page (originally written for people abandoning 'AppleWorks') lists a number of Mac database applications: Their database is rather clunky to use, but at least you can experiment without it costing you anything.įailing that you should be able to export from Access as a comma-separated or tab-separated text file, which most database programs can open (though you won't carry over formatting or formulas - only the results of formulas) so a certain amount of work may be necessary to get it to behave. LibreOffice (free) should be able to open a MS Access Database, though I don't know how much formatting it can carry over.
