Access issue

  • Thread starter Thread starter DiLwALi
  • Start date Start date
D

DiLwALi

Hi
I am currently using a pass-through query to run a SQL stored procedure
- is there a way for me to create a 'make table' query to run the SQL
stored procedure and create a table with the results.

Thanks
 
Hi
I am currently using a pass-through query to run a SQL stored procedure
- is there a way for me to create a 'make table' query to run the SQL
stored procedure and create a table with the results.

Thanks
Click to expand...

You mean a SINGLE query that both returns the result AND creates a table
containing the results. I don't think a MAKETABLE query can return a
resultset. As far as I know, you will have to run two seperate queries to
acomplish that.

One to run the MAKETABLE query and one to return the contents of the newly
created table.

Chris.
 
Back
Top