SQL Pass-Through Query output to Access Table

[Guest]

I have a SQL Pass-Through Query that I have built within an Access Database
application. I want to be able to run this SQL Pass-Through Query and then
output the result table into an Access Table. Right now I have a macro that
"OutputTo" the SQL Query into an Excel spreadsheet. Can I instead "OutputTo"
this into an Access table?? I do not see the options within the drag-downs to
do this??

Any help would be greatly appreciated.

Thanks!

 

[David]

Use the query to create a new "Make Table" query.

hth
David

 

[Guest]

Okkkkkkk...How do I do that???

Use the query to create a new "Make Table" query.

hth
David

 

[Guest]

Follow this stages

1. Create a new query
2. Select the PassThrough query as the "Table"
3. Select the field you want in the new table
4. Change the query to Create new table query (In the menu bar select Query

Create Table Query)

5. Run the query.

 

[dbahooker]

if you used Access Data Projects; this would be a LOT easier.

you wouldn't have to read the data twice for starters.

-Aaron