How do I get a pass-through query to update a table

[Ken]

This is driving me nuts. I have a pas-through query that returns data from a
external database (Sybase). Dat is there and looks good. What I want is to
have the data populate a Access table. Do I have to create the table first or
is there a way to create the table dynamically? I tried the make-table
option but couldn't figure out how to connect it to my query.

 

[pietlinden]

This is driving me nuts.  I have a pas-through query that returns data from a
external database (Sybase).  Dat is there and looks good.  What I want is to
have the data populate a Access table. Do I have to create the table first or
is there a way to create the table dynamically?  I tried the make-table
option but couldn't figure out how to connect it to my query.

use a make table query or create it first and then append to it.
Create the select query, then change the type to a Make Table query
and name the table. Not a lot to it.

 

[Ken]

Thanks. Just figured it out about a 30 minutes ago. Just had to get the
sequence correct. Thanks for the help.