Go Back   Computer Forums > General Computing > Programming
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 07-16-2011, 08:00 AM   #1
Solid State Member
 
Join Date: Jul 2011
Posts: 6
Default Programming in VB.NET! Help needed.

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.
__________________

Master_Key is offline   Reply With Quote
Old 07-17-2011, 03:11 AM   #2
Beta Member
 
Join Date: Jul 2011
Posts: 1
Default Re: Programming in VB.NET! Help needed.

just perform an append operation so the new group of rows from table 1 are simply added on to the end of table 2 - it will mean table 2 will become massive after a while but it works
__________________

minty777 is offline   Reply With Quote
Old 07-17-2011, 08:25 AM   #3
Solid State Member
 
Join Date: Jul 2011
Posts: 6
Default Re: Programming in VB.NET! Help needed.

Quote:
Originally Posted by minty777 View Post
just perform an append operation so the new group of rows from table 1 are simply added on to the end of table 2 - it will mean table 2 will become massive after a while but it works
I have security measures for data. The table should also contain records as old as a year. Thank you.
Master_Key is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 10:18 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0