Ad Hoc Query - Copy and Paste a spreadsheet column into query operator

We would like to be able to cut and paste values from an Excel column into ‘One of’ criteria values in Ad-Hoc Query. For example, we have an Excel containing a column of Lookup IDs or Zip codes and we want to paste these into the 'One of' Lookup ID or Zip code values so we don't have to retype the values into the Query.
  • Guest
  • Jun 29 2015
  • Reviewed: Voting Open
  • Attach files
  • zackary stephen commented
    17 Mar 11:53am

    If this is not going to be included with out of the box functionality, has anyone created a workaround or customized solutions for this?

  • Lisa Fields commented
    23 May, 2019 03:04pm

    Any progress on this since 2015?

  • Deb Hanson commented
    22 Jan, 2019 04:34pm


  • Jess Johnson-Shapter commented
    31 Jan, 2018 02:53am

    Yes! Copy/pasting over 200 postcodes is not my idea of fun, especially when you cannot use postcode ranges in this instance.

  • Guest commented
    20 Apr, 2016 06:24am

    We use this frequently in the Raiser's Edge and would certainly hope to be able to use it in BBCRM.

  • +28