<div>
<div class="content wysiwyg-content">
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 &nbsp;in some &nbsp;words the letters are replaced by numbers. for example &quot;Janet&quot; is displayed as&quot; 01et&quot; &nbsp;and Mary is displayed as &quot;03y&quot;, the problem is that it replaces the abbreviations of month names into numbers.<br />
How would I fix that?
</div>
</div>


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?

Access2010

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.