Access Programming

[coolguy9]

hi every one ,


I have got a doubt regarding MS Access 2003. how can i move data from one table to another table using queries

[puppydogbuddy]

hi every one ,


I have got a doubt regarding MS Access 2003. how can i move data from one table to another table using queries

Try this, replacing the illustrative object names with the object names (tables and fields) used in your application.

Insert Into TableName2 (FieldName1, FieldName2) Select FieldName1, FieldName2 From TableName1;

[coolguy9]

Try this, replacing the illustrative object names with the object names (tables and fields) used in your application.

Insert Into TableName2 (FieldName1, FieldName2) Select FieldName1, FieldName2 From TableName1;

Thank you for your reply but you have explained it in terms of sql but i require it in Access methodology

[MMcCarthy]

Thank you for your reply but you have explained it in terms of sql but i require it in Access methodology

This is Access. Just open the query window in design view without adding any tables. Then switch the view to SQL and paste in this code with you column and table names substituted.

[mclueless]

How will this query work??When vil it run???(i m using access as backend n vb as frontend)...I mean if during runtime the values in table1 are updated then will that immediately be reflected in table2???

[MMcCarthy]

How will this query work??When vil it run???(i m using access as backend n vb as frontend)...I mean if during runtime the values in table1 are updated then will that immediately be reflected in table2???

No this is an action query and has to be triggered. It will only run when you trigger it to run.