Efficient VB.NET Table Archiving: Move Records Between Tables Monthly

  • Thread starter Thread starter Keyur
  • Start date Start date
  • Tags Tags
    Programming
Click For Summary

Discussion Overview

The discussion revolves around the process of archiving records from one table to another within an Access database using VB.NET. The focus is on moving records monthly without deleting existing records in the destination table.

Discussion Character

  • Technical explanation
  • Homework-related

Main Points Raised

  • One participant seeks assistance in moving records from one table to another within the same Access database on a monthly basis.
  • Another participant confirms the operation is to be conducted within the same Access database.
  • A suggestion is made to use an Append Query, which can be written and saved for repeated execution.
  • A later reply expresses satisfaction with the solution and thanks the participants for their help.

Areas of Agreement / Disagreement

Participants generally agree on the method of using an Append Query for the task, but there is no detailed discussion on the implementation specifics or potential challenges.

Contextual Notes

There are no explicit assumptions or limitations discussed regarding the implementation of the Append Query or the specifics of the database structure.

Who May Find This Useful

Individuals working with VB.NET and Access databases, particularly those interested in data management and archiving processes.

Keyur
Messages
10
Reaction score
0
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.
 
Technology news on Phys.org
To another table within the same access database?
 
DavidSnider said:
To another table within the same access database?

Yes, the same access database.
 
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.
 
harborsparrow said:
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.

Done with it.

THANK YOU ALL.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 1 ·
Replies
1
Views
5K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 4 ·
Replies
4
Views
3K
Replies
2
Views
1K
Replies
17
Views
6K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 11 ·
Replies
11
Views
3K