Inserting mulitple rows

G

Guest

Is there a way to create sql to insert multiple rows into
a table through the sql viewer. The data being inserted
is not coming from an existing time. This is a first time
insert into the table. Tried multiple insert statements
but that didn't work.
 
C

cnelson

Did you try creating a temp table and inserting rows into
the temp table and then taking the rows from the temp
table and inserting them into the table you would like to
send them to
 
V

Van T. Dinh

You need to tell use where do you get the "source" for the rows to be
appended.
 
Top