VB Access Table creation from a SQL Pass-Through Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a SQL Pass-Through Query through VB utilizing user-defined date
parameters. Is there a way that I can execute this query and create an Access
Table dynamically based on the result table? I know I've done this before
utilizing a "Make-Table" Query. Should I create a macro that executes the VB
creating the SQL Pass-Through Query with the user-provided begin and end date
and then execute that with another macro step with a Make-Table Query???

Any help would be GREATLY appreciated.

Thanks!
 
you should just use Access Data Projects and then you dont have to deal
with any of this SPT bullshit.

-Aaron
 
Back
Top