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:
Dim opnFileName As String Dim strTempStr As String Dim tableName As String Dim intFileSep As Integer Dim DatabaseName As Database

Code: