newbie to SQL trying to do a report in Excel

[Guest]

I have a SQL query I want to write to pull data to add weely node utilization
percentages.

The db is
area--->headend--->router--->routerports--->transmitter--->nodes--->nodeNames

also node--->utilization

(utilization:nodeID, %, date)
(nodes(nodeID:transmitterID, date created parentnodename)
(NOdeNames:nodenamesID,NodeID)


in my excel report I want to add a new column showing the node data for each
week. Can I get the percentages from SQL into a text file then import into
Excel showing the columns vertically?
One tricky part is one node can be on two transmitters or one transmitter
can have 2 or more nodes. Its just a 1:M but the reason it is important is
the Excel report router data is on only one row. So the nodes can't be on
separate lines the report wouldn't make any sense because we need to know
what router they are on. The nodes are viewed by the user according to the
router port it is on.

Any suggestions on how to do it in SQL and if this can be done in Excel
before I get in to this?

tia,

 

[Guest]

I am going to reword and repost this question.

 

[pietlinden]

I have a SQL query I want to write to pull data to add weely node utilization
percentages.

The db is
area--->headend--->router--->routerports--->transmitter--->nodes--->nodeNames

also node--->utilization

(utilization:nodeID, %, date)
(nodes(nodeID:transmitterID, date created parentnodename)
(NOdeNames:nodenamesID,NodeID)

in my excel report I want to add a new column showing the node data for each
week. Can I get the percentages from SQL into a text file then import into
Excel showing the columns vertically?
One tricky part is one node can be on two transmitters or one transmitter
can have 2 or more nodes. Its just a 1:M but the reason it is important is
the Excel report router data is on only one row. So the nodes can't be on
separate lines the report wouldn't make any sense because we need to know
what router they are on. The nodes are viewed by the user according to the
router port it is on.

Any suggestions on how to do it in SQL and if this can be done in Excel
before I get in to this?

tia,

You can generate recordsets in Access via queries and then use
CopyFromRecordset to send it to Excel.