insert row from row 
Author Message
 insert row from row

is there a nice way to insert a row from one identical table to the next
without having to longhand all the fields or even use a rs.fields(index) in
a loop?
thanks,
mc


Tue, 09 Mar 2004 21:21:58 GMT  
 insert row from row
Michael

Try SQL

INSERT INTO DestinationTable SELECT * FROM SourceTable WHERE
SourceTable.ID=SomeValue (or SourceTable.ID BETWEEN x AND y)

Sukesh



Tue, 09 Mar 2004 22:39:04 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO.NET DataSet.TableName.AddTableNameRow() inserts an extra row

2. table row text will not show after row insert

3. group every 8 rows in 1 row

4. Calculating a field from same row for each row/record in form

5. Getting row number variable from a selected row in Excel

6. adding a table row, without setting same defaults as previous row

7. row heights of table rows added by vba

8. Copy row and past rows not centered

9. Determining actual row height, or setting maximum row height

10. Rows.RemoveAt v. Rows.Delete

11. Add row to datatable from datagrid without leaving current row with cursor

12. Err No rows at, duplicate table and row names

 

 
Powered by phpBB® Forum Software