frubeng
02-26-2010, 06:40 AM
Hello, I have an example spreadsheet that works which pulls information from an external database in excel. However, I would be unable to reproduce it, and was wondering if anyone could explain the steps that i need to take in order to create it.
This is what i do:
Data->Connections->Add
I select a connection set it up as per my example. the sql code runs fine (as in no errors), but then no results appear.
Do i need to name cells for the query?
Thanks, any help on this is very appreciated!
This is what i do:
Data->Connections->Add
I select a connection set it up as per my example. the sql code runs fine (as in no errors), but then no results appear.
Do i need to name cells for the query?
Thanks, any help on this is very appreciated!