Proper Case or Capitalization help

[tshirttom]

I am bringing in excel data that has names in all caps. What is the easiest way to convert to proper case?


For exmple turn 346 S. WASINGTON ST into 346 S. Washington St. Thanks for your help as I am a newbie.

[aytee111]

Use StrConv(fieldname,type). There are different choices with the type to change the case, such as capitalize each first letter (type = 3).

[tshirttom]

Where do I type in the StrConv(fieldname,type)? In a query? Is there a means of highlighting a column and makeing the change to proper case?

Thanks again

[aytee111]

You say you are "bringing in" the data from Excel, how are you doing it? One way would be to have a query populate the table from Excel and you can make the change in the query. Instead of referencing the field from Excel you would put the field inside the StrConv statement. Otherwise you can make an update query after the data is brought in to update the field with the change.

Your second question, I don't know if there is a way. Are you trying to do this manually?

[tshirttom]

Yes because I am a newbie I have been copying and pasting the columns into Access

[aytee111]

Your statement should read: "Because I am a newbie I am trying to learn Access"!! Not to do it the old way, but learning what Access is all about. Your task for today is to create a query to do the task.

1 - link in the Excel file
2 - create a make table query to read the data from the Excel file to a new table.