Update Field In Table With My Own Code

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
 
L

Larry Linson

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
 
A

a a r o n . k e m p f

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
 
B

BruceM

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
 
A

a a r o n . k e m p f

technically it's perfectly relevent.

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

-Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top