How to 'merge' data ?

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I have an Access db and want to merge some data into a particular field.

The field is currently blank.

I've done imports from comma delimited files before but not sure how to
'merge' data into existing records without over writing data in other
fields.

Thanks for any help.
 
What do you mean "merge data"? Are you talking about taking data from two
fields and concatinating it and then storing it in a third field? If so,
the answer is, "You don't."

That would be redundant. Just save the individual fields and if you need to
combine them in your forms, reports, or queries, do it there. You should
never store redundent information in an Access dataabse. A good example
would be storing FIRST name, LAST name, and LAST, FIRST in three fields.
What happens if someone gets married or divorced? Are you going to remember
to fix both fields? In this example, you'd save the FIRST and LAST in two
separate fields. In your reports, queries, or forms, you'd use expressions
to combine them such as...

=[LastName] & ", " & [FisrtName]

or

= [FirstName] & " " & [LastName]
 
On second read, it sounds like you might want to import the data to a new
table, then do an UPDATE query to update the blank field in table1 with the
newly imported data in table2. There will have to be some matching field in
each so it will know which record the data goes to.
 
Rick,

This is what I want to do... as you describe below.

So must I create an Access Basic Script to do this or is their an easier
way? (I haven't done script in quite a while so easy is the way for me if
possible.)

thanks for the help.
 
Back
Top