Hi,
WordPress databases are not compatible with Microsoft Access, so, you won’t be able to achieve this with a backup made by UpdraftPlus or with one by any other tool.
WordPress databases backups are a sequence of SQL ( http://www.w3schools.com/sql/ ) commands that would be used to re-create the database in the event of needing recovery. They can be imported into a MySQL server, and then the server can be browsed using your preferred MySQL tool, such as phpMyAdmin.
David
Just out of curiosity, why do you want to use Access to open the database? What do you hope to achieve?
If you need to browse the database, it is possible to use phpMyAdmin at your web host.
I’m hoping to do some advanced analysis of our order history, and the way the order tables are laid out are fairly complex and would require a query far beyond my capabilities. There is also a high enough quantity of orders that I’d have to do it in multiple segments.
It took me about 6 hours to export from phpmyadmin and import into access three months of orders so that I could even begin to look at how to analyze it. If I’m trying to look at trends in purchasing habits over several seasons, this could take me weeks to do.
If I can export the database and import into access, I can set up preset queries which auto process the tables and could do this on a regular basis.
If anyone knows another way to do this, I’d love to try it.
Hi,
For that task, you should use a WooCommerce export plugin. There is at least one free one, and some commercial ones, available.
David
I have an export plugin which I paid for, but it can’t even export one week of orders without timing out.
