Knowledge base
Microsoft Access
To get your WordPress data into Microsoft Access, you can simply use the External Data feature with an ODBC Connection.
> Before you start: things like this generally go better if you are running MS Access as an Administrator :)
First, you'll need to get your database credentials from SyncHub. Next, go ahead and enter them into MS Access:
Select External Data - New Data Source - From Database - Azure from the Access
We recommend importing the data to your local computer. This will reduce the latency of your queries and give you additional options around indexing etc later
The ODBC Data Source screen will pop up. Create a new Machine data source
It doesn't matter if you choose User or System data source
Select the most recent Sql Server ODBC driver type. At time of writing, this is v17
The Server is provided on your SyncHub Connection Settings - see our quickstart guide
Make sure you select SQL Server Authentication when prompted. Again, you can get these in our quickstart guide
Remember to set the Default database and configure it for Read Only access
You can leave all the other settings on this and the next pages at their defaults.
From here, you'll be able to browse tables and bring in the data you need. Have fun!