Append Query

D

Dawn

I am looking for a way with VBA to run a query against one
table and then append the results of that query to another
table in the same database. The fields are identical in
both tables. Can someone help me out?
 
K

Ken Snell

Can you give us a bit more details? What you ask to do is a reasonable
action, but need a bit more info about what the first query is to do.
 
G

Guest

Sure. I am pulling data from an external source, a SQL
table called ccun_shares and need to query that source
for just the data from the prior day (field is
ccun_biz_day) and append all fields from ccun_shares for
that day to an access table called sharedata. Sharedata
has all of the same fields as ccun_shares.
 
K

Ken Snell

Here is some generic SQL to get you started; post back if more details are
needed:

INSERT INTO ReceiveDataTable
SELECT SourceDataTable.*
FROM SourceDataTable;
 

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

Top