Update Field In Table With My Own Code

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

I used access (2003) for report and analysis. I import text data on monthly
basis from other system into access. I've a big issue on data integrity from
the other system where most of the data is not proper (my term). To elaborate
further pls refer below

Other Sys (EmployerFieldName)
Texas Instrument
Texas Inst
Texas Co

In my case the above employer is the same employer and should be refered as
Texas Co.

I intend to create employer tbl in my access and give a proper name (Texas
Co) for the above records in a new field say myemployername without having to
change the original data in employerfieldname.

Is there any way for me to update in myemployername field say those with
"Texas" in employerfieldname will tag as Texas Co in myemployername. OR is
there any better way to handle this problem

hope that my explaination suffice
 
Before you leap to the solution you describe, you likely should ensure that
there are no other employers in the db with the word Texas in the name...
there are a lot of employers that do. Texas Utilities (TXU), University of
Texas, North Texas Cab Co.

Larry Linson
Microsoft Office Access MVP
 
Maybe you should learn a real ETL tool.

Personally, Access doesn't have 1/10th of the functionality of a real
tool like Informatica, etc

-Aaron
 
Irrelevant again.

message
Maybe you should learn a real ETL tool.

Personally, Access doesn't have 1/10th of the functionality of a real
tool like Informatica, etc

-Aaron
 
technically it's perfectly relevent.

Jet doesn't have basic ETL functionality
Use the right tool for the job ;)

-Aaron
 
Back
Top