Inner Join Query Questions

[David Wetmore]

The VBA documentation says that UNION queries can use SQL statements as data sources.
The documentaion on JOIN queries implies that tables must be used as data sources in JOIN queries.
If this is correct, what is the most efficient way to create a table in VBA and move a recordset into it?

Thanks,
Dave

 

[Rick Brandt]

The VBA documentation says that UNION queries can use SQL statements
as data sources.

All queries use SQL statements. SOME queries can also be represented in the
graphical query designer. UNION queries happen to be one of the categories
that cannot be thus the only way to build them is in SQL view of the query
designer.

The documentaion on JOIN queries implies that tables must be used as
data sources in JOIN queries.

Incorrect. A query that uses a join can consist of tables, saved queries,
or SQL statements.

If this is correct, what is the most efficient way to create a table
in VBA and move a recordset into it?

I suppose the "most efficient" in the sense that it requires the least
amount of code to type would be to execute a SQL statement that is a
make-table query. Most efficient in terms of system resources or speed
would be difficult to say positively without actual testing.

As described, it is unusual to need or want to "move a recordset into" a
table.