View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
fncuis[_3_] fncuis[_3_] is offline
external usenet poster
 
Posts: 1
Default Format on New Database Query


Woah...

Ok, option 1 I think I can handle... basically, have a second worksheet
or second workbook for the presentation side. Do a bunch of linked
columns/cells and impose the formatting there? As I refresh the
(source) workbook/sheet it automatically carries over.

More work, but It's in my latitude.


Option 3: We use a business software called FACTS. It's not the
friendliest program around but allows for ODBC, as I am using it right
now. Correct me if I am wrong, but what you are saying is: during the
database query, "view data or edit in ms query"? and give it my SQL
commands there?


--
fncuis
------------------------------------------------------------------------
fncuis's Profile: http://www.excelforum.com/member.php...o&userid=26466
View this thread: http://www.excelforum.com/showthread...hreadid=397329