Writing a CurrentDb.Execute

Topic

New Reply

Can I write a CurrentDb.Execute to append all of 1 table to another?

Contents of small temp table to std table after checking data is correct.

Reply | Quote

Replies

Yes you can, or you can just run a standard query.

Initially create an append query using the query designer, convert to SQL view and copy the SQL.

Then in your event procedure either
Docmd.openquery “qryYour appendquery”

or
Dim SQL as string
SQL= “your copied SQL’
Currentdb.execute SQL

Reply | Quote