This will all be done inside the Visual Basic Editor (VBE).To get there click Visual Basic on the Developer tab (pictured below) or hit ALT F11. Select MS Access Database* and check 'Use the Query Wizard to create/edit queries'. You can select the table and columns you want to include in your query. Click City from the 'Column to filter' list and only include rows where City equals New York. You can sort your data if you want (we don't do it here). This example teaches you how to import data from a Microsoft Access database by using the Microsoft Query Wizard. With Microsoft Query, you can select the columns of data that you want and import only that data into Excel. On the Data tab, in the Get External Data group, click From Other Sources.
For this example we will rename it (select the class module, press F4) to “cls Query“.
When you're in this table or in this worksheet, if you click in the table, you'll have that new design tab for Tables. Then you have the ability to export it and do a lot of that other stuff.
But usually, unless someone's got different access than I do, they usually don't let you right back to the database.
You control the update schedule, and exactly which information is published to Google Sheets.
Our database connector supports My SQL, Postgres SQL, Sql Server, Oracle, Access, and more.