Mdb Accdb Viewer App Reviews

My marketing agency does a lot of work converting folks from antiquated web systems and this app has come in so handy in the past 6 months! Now with the new export features its even better.

To anyone like me who searched "Excel file viewer" in the app store and was convinced this software was right, beware. It won't open a simple xls file, which is all ai needed. I admit to not understanding the distinction about "Access" files, but this is a big disappointment as I was swayed by the Excel file graphic displayed and all the positive reviews. So, I'm out $19, and have to search and find something usable.

Installed to view large .mdb files with 20+ tabes of up to 4,000 rows each. Program displays well, search and export functions all work well.

Just perfect, did EXACTLY what it said it would and better yet, exactly what I needed it to. Thanks

Great app. But warning: it's only a VIEWER. You can't MODIFY or INSERT data. I was hoping to edit Access files for a project for school. I was able to view it, which was great, but I could not do the assignment so I dropped $19 for nothing. Maybe you guys can make the update that will modify accdb files for Mac?

Perfect if you are given an Access file from someone who doesn't know how to save it in any other format, and you need to import the data into a program on a Mac. Once open for viewing, the data can be exported in a variety of formats.

I've been one of likely many folks who have lamented the lack of a good Access DB conversion tool for mac. This is exactly what I've needed for the past year. Excellent app. Simple and straightforward. It's best feature is the ability to export to SQL or SQLlite. If I could give it 6 stars+ I would.

The program works very well and the interface is easy. I had a pre-1997 .mdb file in the proprietary JET format microsoft was using at the time and the program author converted it for me using a legacy system. Highly recommend.

Been using this app since it came out on the app store. It is so awesome, and a productivity lift. Access was the final application that I needed to run on a day to day to export into excel, but with this app having windows on my mac is not reuired. Saves me 200$ plus the cost of a windows professional office suite (300$)!!! Thanks for the update

My firm does a lot of data conversion. Having this on my Mac makes the process that much smoother. While my PC is getting dusty, they guys added more export options and made the app better at loading large data sets! What's coming next? I can't even imagine. Thanks!

From time to time I get the request to convert an Access database to a web application. It's always been a royal pain to keep an Access license handy + Windows license so I can run Virtualbox or Parallels to get at it. Then, pulling the data out and transferring it was equally time consuming. None of it was rocket science but given that I'm not a fan of Access to begin with, I JUST WANT THE DATA OUT. This app does exactly what I needed…gives me the database tables and lets me export them in several formats. Loving it. Also, had one issue with the export of a table. Contacted the developer and had a response same day. Turned out that the exact issue had been addressed by the 2.2.5 update and I was running 2.2.4. Thankful for the quick response and that my problem was already addressed. I'm a fan.

Be nice to query select data (joins) and see table schemas (type/lengths). If you need to simply view the contents of a table, then this works fine. Price vs value a bit off but my opinion is based on only 5 minutes of usage. The time it takes to export to a file and do analysis is the same as loading my vmware copy of Windows/Access and hit the data directly.

Don’t waste your time

While I wish this application had more features, it does allow me to view all of my Access database files, so I'm happy about that. The ability to export is a big plus.

Obviously if you have a VM with Windows Access and need to view / select / edit Access files, then you don't need this tool. But if you have a Mac and simply need to view Access data, and/or need to convert Access data to another database format quickly and easily, this tool is it. And the price couldn't be better. Out of the blue I had to convert a fairly large Access db to SQLite. I toyed with the idea of writing a quick converter, but decided to check online first. Found this gem and had it converted in minutes. It saved me time and was well worth the cost.

I found this when given an Access DB to analyze for porting to mysql. It works as advertised. I'd give it 4.5 stars- the only missing feature is a relationships map. Nothing fancy necessary, but a simple screen that shows table relationships would be the extra .5 star. Thanks for a useful app!

It would be great if the description had indicated it doesn’t support encrypted ACCDB files. We are unable to open the file.

it is SUPOSSED TO READ access but it really DO NOT OPEN IT!! it is really a really poor program: i have an access db and first i have to put it in 2003 format, then, it does not read the forms, the querys or the reports: so you have a great program that just read the tables like a msdos program. Sincerelly, i do not recomend it

I searched and searched on the search engines for a way to be able to read and convert an ".mdb" file to a CSV for a project that I was working on. Nothing but stuff for Windows and many posts for "impossible", obscure antiquated things like a coomplicated setting up of ODCB etc…. Then realized the contextual menu for open with… search Mac App store and found this… Worked perfectly, can read everything, see everything and export everything. Nice clean interface, intuitive and does exactly what it says it will do! Very happy!!!

Saved me a lot of time (& money as a result). Simple, easy to use.

If you need to move Access data to a Mac, you need this app! Worked like a charm for me!

Great app. I needed to open an old Access DB and export the data into CSV format. App worked as advertised!

Excellent software as well as quick and friendly customer support! I purchased this with some hesitation due to the price. However the reviews were great so I took the plunge. In reality, the price is not bad for this type of software. MS Access was the last piece of software I needed to dump before I could lose Parallels and Windows on my iMac. I run R for statistical analysis and needed a Mac-friendly way to export MS Access files to CSV for import to R. This software is extremely fast and reliable for doing just that. The other exports work seamlessly as well. The CSV export allows you to export each table in your MDB separately (not currently all at once). The Excel export will give you one workbook with different sheets for each of the tables in your MDB. I havent messed with the other export options yet. The only issue I had was not at all related to the software but the issues inherent in CSV files (quoted strings and commas in text fields), which caused my columns to be messed up on export to CSV. Again, this is not an issue with the software, just with my data and the CSV file type. I emailed Jakob to see what was up with this and he responded within a half an hour with a friendly and helpful response. For the time being, any tables I have that have quoted strings are getting exported to Excel, I remove the quotes with a find/replace, and save as CSV. I had to do this exporting directly from Access anyway, so it is still a huge time saver. Bye bye windows!

It works like a charm! Very easy to you and plenty of export options!

Chose MDB Viewer wisely from many similar apps. Quickly converted 9 year-old Access files into Excel for Mac. Tech Support by the developer was offered if any problems occur. Jakob Eggerprompt was prompt and very helpful in converting a problem file. Highly recommend this useful app.

Had an issue converting client's little mdb file to MySQL, and boom, done, hours saved! Thanks so much Jakob. Worked exactly as it should.

This is great for viewing an MDB file, but you don't get much else. You can look at tables, that's it. No edit, no querying, nada. For $5.99 it's a great deal. MS Access was overkill for my needs anyway - glad I didn't have to install it on a VM. You do get exporting to a CSV - so if you need to, you can export to CSV and open it in MS Excel 2011 to do some heavier work no problem.

THANK YOU. This app is a VIEWER, and helped me export my files to a more friendly format since I don't use Access anymore. I tried a cheaper app, but didn't work. This app was lightening fast and all of my data came through beautifully. I don't really know that I will use the app frequently, but since it did exactly what I needed it to do, I am able to enthusiastically recommend it.

I've used several Access converters before, some CLI and some GUI, and while others have more bells & whistles, they also would crash or be unable to extract data from certain Access db's due to unusual table structures, large size, etc. MDB viewer flawlessly handled all of them - over 100 Access dbs, each with 100,000+ records and file sizes in the hundreds of MBs, and exported them as SQLite compatible SQL; on a high-end 2008 Mac Pro, it took under 9 minutes to generate 2.78 GB of SQL from a 700 MB Access db. One wish - make it Applescriptable so I can automate it the next time I have to do work like this! :-)

This application works perfectly. not like other poor migrators.

Works great for viewing data, however when it comes to exporting into MySQL it's rather lacking. It produces chunk inserts (where it inserts the entire contents of a table in one insert as opposed to many), however there is no way to control this. It's all-or-nothing and in all of my uses I could not load the resulting SQL file into MySQL due to max_allowed_packet being exceeded. Increasing this value is not an option so the ability to control this prior to export would be the only way to make it useful. If it weren't for this, I would give the app 5 stars.

The absolute easiest way to export an entire Access DB into something more accessible (I predominantly convert stuff to SQLite using this tool). Sold work

A client sent me an Access database file and since I don't have Access I could not open it. Found this app and decided to take a chance. It worked perfectly and easily. I was able to a) view the file using the viewer, and b) export it to Excel. In seconds. I'm not an Access user or dBase expert, but this app did what I wanted it to do.

Great if you don't have access to Microsoft Access and only have a Mac. Can very quickly display the contents of the database in full. However, sifting through the data can be daunting as the find functionality (Command-F) seems to be broken (i.e. can't find all rows with column_value = 10).

This product did exactly what I wanted — exported a large access database into a MySQL compatible dump. It is strange that the only working tool I have found for migrating .accdb files comes from a single developer who wrote a product for the Mac platform. This is well worth the $20 dollars. This will save me lots of time and surely impress my colleagues.

MDB Viewer for OS X is a great application to view Microsoft Access database. The SQL/CSV dump is a unique feature that even Windows-native MDB viewing programs fail to implement. While lacking direct editing / saving of MDBs, the lack of the ability to view table schemas and print schemas is a big disappointment. I feel that it is a fundamental feature which should be integral in any database viewing or manipulation apps. At its price, it is a very solid app and worth every penny.

I needed to convert an access database for use on the Mac. This software was able to open it with no issues. I was able to export to CSV and as excel and then import it into BASE (open office) - It even preserved the tables for me. When I had a question about how it worked - I emailed Jakob Egger - and he responded with in 30 minutes. Excellent customer service! Thanks again.

works great you can export any table you want .

I was about to write my own custom MDB converter, and was therefore very happy to find the developer's link to this solution at the macworld forums. I certainly couldn't write my own translator for $5.99! Thanks for saving me a lot of time and effort with this app. I installed the software, started it up, located my MDB file, and MDB Viewer quickly opened the database. I then converted it to CSV and I was on my way. The whole process took less than two minutes. Two feature suggestions: 1. Improve auto-sizing of columns. Some columns seemed to auto-size for me, but others didn't. My state column, for example, was twice as wide as its label (STATE_PROVINCE), though no value in that column was nearly as wide as the label. 2. Allow dropping of files from the Finder into the application's initial window. One can drop MDB files onto the application's icon, but the initial app window leads the user to intuitively drag and drop into it. After clicking Open Other…, a user can drop their file into the Open dialog, but most users don't know this, it requires extra clicks, and again, it isn't intuitive. Absence of these minor conveniences aside, great app, and great value. Thank you!

I’m using this to export to excel so I can then import to a new Filemaker solution. It only took about 7 seconds to export a table with 180k records…MUCH faster than using Access’ export feature. If you don’t have access, or it crashes often like mine does, and you need to view/export mdb/accdb files, this is the perfect tool.

The SQL export supports MySQL, PostgreSQL & SQLite, each with 3 checkboxes: Export Structure, Include DROP TABLE, Export Countents … and a choice of the current table or all tables. Importing the data to Postgress worked fine, as did generating a SQLite file directly. The developer’s Postico is also great.

Worked like a charm, otherwise would have needed to recreate 377 records of data.

I had to open up an MDB file quickly so I purchased this with my fingers crossed. I was pleasantly surprised that it had options for exporting to SQL statements (with options for MySQL, PostgreSQL, and SQLite formats). And mostly for it's export to SQLite itself. Made my job a ton easier. This is a great, great find.

Just a heads up that this doesn’t always work with databases created in newer versions of Access. It’s not real obvious from the description, and initially I was very disappointed when I saw "MDB ACCDB Viewer supports MDB, ACCDB, MDE and ACCDE files created with Microsoft Access 1997-2013. Later versions are not supported” pop up on my screen. I tried it on a second, very clean and simple DB created with the newer version of Access, but the big DB which used more sophisticated features bombed. The good news is since I bought this mainly for a back-end migration to MySQL, I was able to copy my tables to a new database saved as an older version, then export the SQL and load into MySQL. Everything else about this app is extremely well done, as pointed out by other reviewers. Lightning fast, clean UI, etc. But a shame to not keep such a great product updated to keep up with Access.

As one may imagine, there aren't a lot of reasons a mac user would be looking to actively work with MDB files. However, I have a client who wanted a legacy Access database converted to a MySQL based web application. It was an "old version of Access" - the client had no idea, and the current version of Access wouldn't open it up. I downloaded this app to see if I could at least view the data. I saw the "export as SQL" feature but honestly I haven't had much luck with those in the past - especially from MS applications. Well, I can say this was worth probably twice what it costs. It opened the 150MB .mdb file in about two seconds, and exported it to a full MySQL dump in about 3 minutes. I imported the resulting SQL file into MySQL with no errors, no data loss, and from what I can tell all data types/keys in place. Well done!