PDA

View Full Version : Programming in VB.NET! Help needed.

Keyur
Jul16-11, 07:00 AM
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.
DavidSnider
Jul16-11, 07:04 AM
To another table within the same access database?
Keyur
Jul16-11, 10:49 AM
To another table within the same access database?

Yes, the same access database.
harborsparrow
Jul24-11, 10:24 AM
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.
Keyur
Jul25-11, 08:51 AM
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.