Exporting Upper Case Test 1

[nisbets]

I am doing some data conversion work from a legacy system and I am using Access 2000 to manipulate the data. At the end of the process I need to export the data to Excel.
My problem is that I am using the table field format to auto-capitalise text but when I exporet to Excel it goes back to its original case. Is there any way to change the data to upper case and keep it that way.

P.S. I know about the =UPPER() in Excel but I have to convert more than 2 million records and I wish to automate the process as much as possible

 

[hennep]

you can create a query to convert to uppercase
for example:

select ucase(col) from tbl;

and export the query instead of the table.