SQL syntax

  • Thread starter Thread starter mary tate
  • Start date Start date
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
 
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
 
Back
Top