Proper Function

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

Access 2003,

I have a huge table of 165,000 records that I have to import into Access.
There is a name field that I have to convert to First letter Upper Case and
the rest lower Case letter, in other words using the proper function from
Excel.

I have tried doing this in Access but no luck.

How do I achieve my goal in Access. I know that I can export part of the
table at a time into excell and do the conversion there but that is crazy.

Thanks For your time.

Bob
 
Robert
I have tried doing this in Access but no luck.
Click to expand...

Without a better idea of what you've tried, the 'group readers may just
suggest the same thing you've already done.

Have you looked at an Update Query and the StrConv() function?
 
Thanks Jeff.

the StrConve worked just fine. I must be an idiot or that function was not
in A2K.

Another question if you have the time. Does A2K have a function like excels
CInt. I know that it has Int but have not been able to use the Cint
Function.

Thanks Again for your help.

Bob Raley
 
Access does have a Cint function. It converts text that is numbers to an
integer. It does have a limited range Plus/minus 32K.
 
Back
Top