| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| 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) | |||
![fncuis[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
