Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
query sql database
Hello everybody
I need to import in a Excel sheet data from a Microsoft sql database, I need the filtered data from some fields from one table and from a other table which needs to be linked with a field the calculated sum from the many related records. Table one Table two, item nr. field to be linked with table one filtered item nr-------------------------------------item nr / quantity quantity quantity quantity --------------------- sum sheet result item nr sum (quantity) I can do everything except get the single result from the summed quantity field Anybody a idea how to achieve this? Thanks Walter |
Reply |
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) |