Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Data (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • Importing data from large (840MB) XML file into Excel 2007

    The State of WA posts .xml data extracts each week. Too bad they are so large I think I'll need a Cray to open it. Even trying to map and then import just one element, I get an XML parse error. Reason: "Not enough storage is available to complete this operation..." I have at least 250 gigs...
    Posted to Data Exchange (Forum) by Cal Fuqua on Mon, Jun 14 2010

  • Data Sources in Excel with VISTA

    Hi Got a problem with Excel running on Vista and data sources, we have a set of excel spreadsheets which run fine on an XP system connected to our main SeaChange data base (UNIX) and Microsoft Query works fine as well so that we can change the data query. But when we try to run the same files on Vista...
    Posted to Data Exchange (Forum) by Kenmoore on Wed, Oct 14 2009

  • MSQuery Parameter in WHERE to default to All (including null)

    I need an Excel parameter prompt where the user can get a list of ALL items or only the KVI items. I've tried WHERE Unit = [Enter Unit] OR [Enter Unit] IS NULL. It works great in Access, but I get a syntax error in MSQuery. I tried using a single prompt in MSQuery, but when I input % wild card only...
    Posted to Data Exchange (Forum) by AFSkier on Wed, Aug 19 2009

  • Access Export Query newline characters appear in Excel

    I have an Export Query set up in Access 2007 (linked to SQL Server 2005 tables), which exports to an Excel 2007 spreadsheet. On my PC, it displays correctly, but on another user's it shows the newline characters (or 'carriage returns', in 'memo' fields) as small boxes, which also...
    Posted to Data Exchange (Forum) by Steve C on Tue, Jun 16 2009

  • Formulas in hidden columns not copying down when updating Queries

    I'm using MSQUERY to pull data from our business system so I can do further summary and evaluation. I have multiple columns of formulas to the right of the query. I am having trouble with formulas in hidden columns not copying down. Formulas in columns to the right of the blank areas will copy down...
    Posted to Data Exchange (Forum) by Omar on Sat, May 30 2009

  • Re: Display the Edit Query Dialog

    Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
    Posted to Data Exchange (Forum) by Rembo on Wed, May 21 2008

  • Passing a list from Excel to MS Query

    I've tried this several ways, but no success so far. Is it possible to pass multiple values from an Excel cell as parameters in a Data query? In MS Query, this looks like "IN (1,2,3,4,5)". Or, calling a parameter looks like "[List]" which can be tied to one worksheet cell. However...
    Posted to Data Exchange (Forum) by Omar on Sat, Jan 26 2008

  • Welcome to the data exchange forum

    Welcome to the Excel Data Exchange Forum You should post any questions on getting data in and out of Excel here. You can use just about any technology to do this, XML, ODBC, OLEDB, Web, etc. Have fun
    Posted to Data Exchange (Forum) by Nick Hodge on Sat, Jan 5 2008
Page 1 of 1 (8 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.