View Full Version : Excel data Connections to pull data

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:
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!