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

  • Thread starter Thread starter Keyur
  • Start date Start date
  • Tags Tags
    Programming
AI Thread Summary
To move records from one table to another within the same Access database using VB.NET and the Jet OLEDB provider, an Append Query is required. This query allows for the addition of records from the source table to the destination table without deleting any existing records in the destination table. Once the Append Query is successfully created, it can be saved and executed on a recurring basis, such as at the beginning of each month, to facilitate the archiving process. The graphical user interface (GUI) of Access can assist in constructing this query.
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.
 
Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
I had a Microsoft Technical interview this past Friday, the question I was asked was this : How do you find the middle value for a dataset that is too big to fit in RAM? I was not able to figure this out during the interview, but I have been look in this all weekend and I read something online that said it can be done at O(N) using something called the counting sort histogram algorithm ( I did not learn that in my advanced data structures and algorithms class). I have watched some youtube...
Back
Top