Hello Everyone,

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

The data that comes out of our business software, well... to say the 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, so naturally, when i open up excel, and refresh, its right back to the raw, unformatted data.

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

Can someone point me in the right direction?

Thanks,