Case transformation

[tshirttom]

I need to simply bring in Excel spreadsheet with all CAPS in the address and
convert it into a first letter only CAP.
For example:
convert 44 HARRISON ST in Excel to 44 Harrison St in
Access


I would appreciate any help in doing this in the simplest manner.

thanks,
tshirttom

 

[fredg]

I need to simply bring in Excel spreadsheet with all CAPS in the address and
convert it into a first letter only CAP.
For example:
convert 44 HARRISON ST in Excel to 44 Harrison St in
Access

I would appreciate any help in doing this in the simplest manner.

thanks,
tshirttom

Import the data as is.
After you have it all imported, run an update query on the Address
field:

Update YourTable Set YourTable.[Address] = StrConv([Address],3)

Note: this will cause some words in the field to be capitalized that
ought not be, i.e. van Beethoven Avenue (Van Beethoven), and some
words will be incorrectly capitalized, i.e. McDonald Street (Mcdonald
Street).