Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

2012-11-11 Thread Anoop K Sharma
Before importing data use the following function =clean(your expression) On Fri, Nov 9, 2012 at 5:39 PM, Mangesh Vimay wrote: > but how? > > Can you help me please. > > On 11/9/12, Anoop K Sharma wrote: > > Use Clean function > > > > > > > > On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay > > wr

Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

2012-11-09 Thread Mangesh Vimay
but how? Can you help me please. On 11/9/12, Anoop K Sharma wrote: > Use Clean function > > > > On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay > wrote: > >> Hi Friends, >> >> I need your help. >> I have Excel file containing some data. I have import this data to MS >> Access 07 table by using Ap

Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

2012-11-08 Thread Anoop K Sharma
Use Clean function On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay wrote: > Hi Friends, > > I need your help. > I have Excel file containing some data. I have import this data to MS > Access 07 table by using Append query. > But when I access the table, it contains some un-wanted characters like

$$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.

2012-11-08 Thread Mangesh Vimay
Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like "question mark in square i.e. [image: Inline image 1]", etc. I want to remove these cha