I want to copy/apend last two weeks table data into another existing table

• naeemhaq

  Newbie

  Points: 9

  More actions

  January 26, 2009 at 4:52 am

  #72372

  Hi,

  I want to copy/append last two weeks data into another existing table with exactly same schema.

  I cant to select * into becuase it just replaces all data and i think we need a new table for it because i can not use select * into for an existing table plus i want to keep my data in both tables i dont want a replace.

  Can anyone please help, sorry for asking a vague question.

  Thank you

• jfmccabe

  SSCrazy

  Points: 2547

  More actions

  January 27, 2009 at 1:16 am

  #933038

  INSERT INTO existingtable

  SELECT * FROM OtherTable

  WHERE OtherTable.Datefield = some condition

  Should do the job.

  In Access query design, look for an append query. that will do the job for you.