Hi,
Does anyone know the VBA or SQL code to add all records from a table to another table in access. I think it's called "Append" in access.
Thanks!
Hi,
Does anyone know the VBA or SQL code to add all records from a table to another table in access. I think it's called "Append" in access.
Thanks!
Create your append using the QBE. Look at the SQL statement that was created by Access. Copy and paste it into your VBA code.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi,
Where to get this?
Thanks
Where to get what? The SQL is available when you create the query in the QBE.
I believe it is time for you to acquire a book on access to learn the very basic issues that you are posting to this forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks