Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Nick Hodge's Excel Blog » All Tags » External Data (RSS)

Browse by Tags

  • My First 15 Minutes?

    Everyone will be famous for 15 minutes... dunno who said that but as many of you know I live a double life as downright nice, jolly chap on one hand and geek on the other! Some time ago I wrote a blog about getting External Data into the new 2007 version of Excel. Well, it grew a little into a full-blown article and it has just been published on the main Office Online web site at Microsoft.com. The article is here ...end of 15 minutes and back to obscurity!
    Filed under: ,

  • Excel 2007 - Getting External Data

    On of the most visited parts of my web site is the part on external data. Most of it was based on Excel 2003 and before, so I thought I should update it for Excel 2007. INTRODUCTION The first thing you will notice about 2007 is the ease in which you can find the data 'movement' tools. Now, say what you think about the ribbon in Excel 2007, but finding where to import and export data is not one of them! It's on the Data tab. (as below) I have only shown you the section above. The tab extends...

  • Importing Data with Parameters (ODBC)

    Using Parameters In External ODBC Data Queries Here we can demonstrate the linking of data in an external data source with Excel, using the values in cells to determine the data presented, using parameterised data queries. Open a workbook and on the active sheet in cells A1 enter Start Date and in B1 enter the date 01/01/2003. In A2 enter End Date and in B2 enter the date 02/02/2003. Take the menu options Data>Import External Data>New Database Query... You will fire from here a dialog asking...
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.