persistent recordset

Results 1 to 2 of 2

Thread: persistent recordset

  1. #1
    Join Date
    Dec 1969

    Default persistent recordset

    i hv created a data file using a select query on Machine 1. now this data file i am transporting to a different machine 2.<BR>how to append this data to the db of machine 2 which has the same db structure as that of machine 1.<BR>one way is i know the structure of table so i will retrieve each value and then insert.<BR>can i do this w/o doing above i mean directly insert the values of data fileinto the table.<BR>thanx

  2. #2
    Join Date
    Dec 1969

    Default RE: persistent recordset

    1) If the data is retrieved in exact column order, you can shortcut your insert statement by not including the field list.<BR><BR>INSERT new_table VALUES (value_list)<BR><BR>2) or you could do:<BR><BR>INSERT new_table (field_list)<BR>SELECT field_list FROM old_table<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts