Field formats not being exported properly

[aggicort]

I'm having trouble in Access 2003 with a field I formatted to be all upper
case not holding that format when exported into Excel or SPSS. The data
orginally came with some records being all upper case and some using upper
and lower, and the original way it was entered is what's being exported, not
the newly formatted. When looking at the data in Access, the format works
great. I don't understand why it would be fine within Access, but then not
hold in Excel. Any help would be greatly appreciated. Thanks!

 

[John Nurick]

If you apply a format to a field in Access, that affects the way the
data is displayed, not the actual data - and it's the latter that's
exported. Create a query that uses a calculated fields to convert the
data to uppercase, e.g.
fMyField: StrConv([MyField], 1)
and then export the query.