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

  • Thread starter Thread starter Ken
  • Start date Start date
K

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.
 
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.
Click to expand...

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.
 
Thanks. Just figured it out about a 30 minutes ago. Just had to get the
sequence correct. Thanks for the help.
 
Back
Top