How to Populate Data from a table to another

M

MS001

Joined
Jun 11, 2023
Messages
1
Reaction score
0
I have 2 tables A & B. A is a summary table and B is a breakdown of table A. I want to achieve that whatever is entered in Table A reflects in Table B.

jUIeZ.png



ReSql = "INSERT INTO " & XGetListObject(Sheet1.ListObjects(1)) & "([Account?],[count of'
'invoices],[value],[Percent]) " & _'
'"SELECT [Account?],[count of invoices],[value],[Percent] FROM "'
'& GetListObject(Sheet2.ListObjects(1)) & " as T2"
 

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

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to setup database to make transactions (transfers) between two bank accounts 0
How to Delete duplicate row access 2003 0
How to export table from outlook into ms access table? 0
How to copy and paste only visible cells from Excel using vbscript 0
Adding a column to a table 4
Access Validation rule of 1 field based on a field of another table 1
Populate word footnotes from table 0

Top