Proper Function

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
 
J

Jeff Boyce

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?
 
R

Robert Raley

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
 
J

John Spencer (MVP)

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