Sometimes it is necessary to export a table to create a backup, share data with a team member, or whatever... Here is how you export a table using the File Dialog object in Access with VBA. This example will work in Access 2007 - 2013. UPDATE 02/16/2015: Added reusable code for file save-as dialog box. Create a new module or add the following code to an existing … [Read more...] about File Dialog Save-As in VBA Export Table by Name | Microsoft Access