Append Query

[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?

 

[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.

 

[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.

 

[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;