| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format on New Database Query
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
