Showing Query Results from VBA SQL Query

P

PiB311

Hello all,

I am running into an issue showing results from a VBA SQL query that I need
to export to Excel. Its nested within a loop sequence, and will run for each
individual in a certain work group.

I have used the following code before and am just looking for they way to do
it a VBA SQL dataset.

DoCmd.OpenQuery "Query1"
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy
 
Top