Hello Everyone,

I am connecting through Excel to my company's business software vi
ODBC.

The data that comes out of our business software, well... to say th
least, its not very database friendly. Lots of spaces, ALL CAPS (ugh)
and requires concatenation on multiple columns.

The data I import will be refreshed nightly from the software, s
naturally, when i open up excel, and refresh, its right back to th
raw, unformatted data.

I would like to know if at all possible, a way to "lock-in" my command
and formatting, so that when I do refresh the linked data,
automatically impose my formatting on it.

Can someone point me in the right direction?

Thanks

--
fncui
-----------------------------------------------------------------------
fncuis's Profile: http://www.excelforum.com/member.php...fo&userid=2646
View this thread: http://www.excelforum.com/showthread.php?threadid=39732