Export Access Tables to Other Formats Using a SQL Statement
Version Compatibility: Visual Basic 6
You can use a Common Dialog control placed on a form somewhere to use this, or set opnFilename to the complete path and filename with extension. Also you will need to have Microsoft DAO 3.51 or 3.6 referenced. From what I have seen and used so far, the table name must not have spaces in it to do this. I personally just temporarily renamed the table and then used it.
Instructions: Copy the declarations and code below and paste directly into your VB project.