VB Access Table creation from a SQL Pass-Through Query

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!
 
D

dbahooker

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

-Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Through Make Table 7
Pass through query how to run in VB code. 8
SQL Pass-Through Query output to Access Table 4
Pass-Through Query with Parameters from a Table 1
SQL Pass-Through Query with User prompted parameters 8
Pass Through Query to Sybase SP 18
Linked Tables vs Pass-Through Queries 2
From Access how to create stored procedure in SQL server 4

Top