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
 
You must log in or register to reply here.

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

Appending records from one table to another 1
Access 2010 append query to SQL is very slow 0
Appending records with sub-records into single row 7
Merging Multiple Tables With Same Fields into Single Query 4
Dataset - Relations vb 2005 3
SQL statement in Visual data manager 1
insert into and repeating values 2
Access Click in Table to Open Form 0

Back
Top