Solved

Access2010

Posted on 2012-03-14
1
213 Views
Last Modified: 2012-03-27
I have db in Access 2010. The tables data in the db are imported from oracle aql. I ran select * on all tables on sql server,saved them as text file and then imported the data to accsess. one of the tables has first_name column (text) , the problem with that column is that  in some  words the letters are replaced by numbers. for example "Janet" is displayed as" 01et"  and Mary is displayed as "03y", the problem is that it replaces the abbreviations of month names into numbers.
How would I fix that?
0
Comment
Question by:lojayn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 37720022
Brute force method would be to run an UPDATE Query repeatedly on the column:

UPDATE YourTable SET YourField = Replace(YourField, 0,"")

and repeat that, replacing 0 with 1, then 2, then 3...

That is assuming that your data is never expected to have these digits


EDIT ---  Retracting this.  I misread the question as these digits being embedded in good data.  It will remove the digits leaving text that it was embedded in.

This won't work if the bad data has completely replaced good data.
0

Featured Post

PowerShell Core for Advanced Linux Administrators

Understand advanced principals around Powershell Core with a focus on the Linux Administrator.  This course covers how to administer numerous environments across multiple platforms including Linux, Azure, AWS, and Google Cloud from a single shell instance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question