+ Reply to Thread
Results 1 to 2 of 2

MS Query not returning all data to Excel

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    Stafford, England
    MS-Off Ver
    Excel 2007
    Posts
    87

    MS Query not returning all data to Excel

    Good afternoon all,


    I am having some issues in getting this data to return to Excel.

    , INGlobalInvoiceHeader_0.cono AS 'Your Reference'
    , GROUPCONCAT(INGlobalInvoiceHeader_0.invno) AS 'Invoice Details' "there is a _ between Group and Concat"
    , SUM(INGlobalInvoiceHeader_0.totval) As 'Total Value'

    The query works in MS query and returns three columns, but when it is passed to excel it drops the 'Invoice details' column in its entirety. Is anyone able to offer some assistance?

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: MS Query not returning all data to Excel

    Are you using a SQL Server from where the Data is being retrieved?
    Cheers!
    Deep Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Returning data from Microsoft Query to Excel
    By rainbowforest in forum Excel General
    Replies: 3
    Last Post: 06-27-2013, 05:17 AM
  2. Excel web query is returning blank data
    By panditji in forum Excel General
    Replies: 2
    Last Post: 06-25-2013, 04:43 AM
  3. [SOLVED] query table returning no data
    By Confused_need_help in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 08:14 PM
  4. Microsoft Query not returning same data back to Excel
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2012, 02:51 PM
  5. returning data from microsoft query
    By mintmin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2009, 02:13 AM
  6. [SOLVED] SQL Query not returning correct results
    By Stephen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2006, 08:25 AM
  7. Replies: 3
    Last Post: 03-11-2006, 06:15 PM
  8. Returning data to Excel sheet from MS query
    By SNB in forum Excel General
    Replies: 0
    Last Post: 04-26-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1