Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Media » Non Excel Files » Videos » Using Worksheet Parameters On External Data (Video)

Using Worksheet Parameters On External Data (Video)

Browse Media

Tags

View more

Previous | Next | View all files | View Slideshow
posted by Nick Hodge
Fri, May 16 2008
Downloads: 66
File size: 6.6MB
Views: 505
Using Worksheet Parameters On External Data (Video)
Filed under: ,

This file shows data being brought in from an Access database, into Excel 2007, using MS Query (ODBC) and parameters that are based in cells on the worksheet and update the query by changing these.

 

Comments

Roger Govier wrote re: Using Worksheet Parameters On External Data (Video)
on Mon, May 19 2008 4:44 AM
Nice explanation Nick
Roger Govier wrote re: Using Worksheet Parameters On External Data (Video)
on Mon, May 19 2008 4:50 AM
Nice explanation Nick. Well thought out and delivered at an easy to understand rate
Alex J wrote re: Using Worksheet Parameters On External Data (Video)
on Tue, May 20 2008 1:08 PM
Nick - as allways an excellent piece. Yes, I did learn something, and yes, I will use it today. Thanks
sam wrote re: Using Worksheet Parameters On External Data (Video)
on Wed, May 21 2008 4:53 AM
Nick Can you also add in the video how to use multiple parmameters in a query. For example is a range of cells A1:A10 has different products, how to use data from A1:A10 as parameters for a query Sam
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.