Export Access Tables to Other Formats Using a SQL Statement

Category:
Database
Type:
Snippets
Difficulty:
Intermediate
Author:
Jeff Winn

Version Compatibility: Visual Basic 6

More information:
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.

Declarations:

Code: