SQL syntax

M

mary tate

Iam new at VB. I am in VB and using the VB data manager.
What would be the correct SQL statement to take all the
records from one table to append them to another table in
the same dataset?
I have a dataset with 5 tables.

Any help would be GREATLY appreciated!

Mary
 
N

Nikos Yannacopoulos

Mary,

Make a new append query to do what you want manually, and
change view to SQL; Access will make the SQL statement for
you!

Nikos
 
Top