convert column name to upper case

[#1]

Hi all,

Hope all having great weekend.

I'm reading data from multiple xls(100+) files by using a loop.

Problem:

1. case of column names is inconsistent so while concatenating data from each file it creating multiple columns.

Ex: State (from first xls) , state(from second xls) is bought into 2 different columns instead of one due to case inconsistent in xls files.

I tried "Force case upper" but it is converting data to upper case.

Thanks

Ranjith

[spring101]

This has been answered well, but there is an easier solution.

force case upper;