Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Update Scenerio...

Status
Not open for further replies.
bengalliboy

bengalliboy

MIS
Oct 22, 2001
215
US
I need an easy way to update a database where VB is used to insert record from an Acces table. The criteria is to compare the old data (I got an old table and a new table and data is inserted to new table) w the new data and if it is not there then do the insert and if it is there then modify it (Assuming something changed..)

I want to do this in one step either using SQL or VB whatever easy way it can be..
TIA
 
Status
Not open for further replies.

Similar threads

aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
142
aldi07
aldi07
pmrsed
  • Locked
  • Question
Excel VBA to Update Word InlineShape using Heading 1 Alternative Text
Replies
1
Views
162
strongm
strongm
mjassalina
  • Locked
  • Question
Force closed or Crashed when Clicking Update/Save Button Userform Excel VBA 1
Replies
19
Views
172
mjassalina
mjassalina
Candia Huang
  • Locked
  • Question
How to update the TOC header number when I hide some section in word document use VBA
Replies
1
Views
98
macropod
macropod
MattGreer
  • Locked
  • Question
Recalculate Radio-Button-Selected VBA Functions When A Cell Is Updated 2
Replies
18
Views
300
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top