Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Programming in VB.NET! Help needed.

  1. Jul 16, 2011 #1
    I have a table in access, it is linked to vb.net by jet oledb provider. I want to move all the records of this table to a new table which may already contain records. I have to move all the records of table 1 to table 2 at the 1st of every month. Table 2 may contain records, these should not be deleted.

    Can anyone help with archiving of these records. Any help will be appreciated.
  2. jcsd
  3. Jul 16, 2011 #2


    User Avatar
    Gold Member

    To another table within the same access database?
  4. Jul 16, 2011 #3
    Yes, the same access database.
  5. Jul 24, 2011 #4


    User Avatar
    Gold Member

    The GUI can help you with this. You need what's called an Append Query. If you write this successfully, you can save it and re-run it anytime you want to.
  6. Jul 25, 2011 #5
    Done with it.

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook