web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Quick Query copy to Ex...
Microsoft Dynamics SL (Archived)

Quick Query copy to Excel, SL 2015

(0) ShareShare
ReportReport
Posted on by Community Member

After upgrading from 2011 to 2015 the 'Copy to Excel' function from Quick Query is sending over all the trailing spaces after each field.  This behavior was not present in SL 2011.  Does anyone know a way to suppress the trailing spaces using while using the copy function?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I am trying to recreate what you are seeing, but I am not able to.  Can you supply exact steps so I can see if I can recreate it?

  • Community Member Profile Picture
    Community Member on at

    Capture2.JPG

    Capture2.JPG

    Hi Jeremy,

    Currently, if users select 'Copy To Table', we get the trailing spaces in the Excel document.  It works normally when using the 'Query Table' option, but we don't have the database opened up to users in that manner.

    Trailing spaces which cause problems when users attempt to create formulas against the data (vlookup, match, etc):

    Thanks.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    I now see what you are seeing.  It looks like more options were created in SL 2015 and the "Query Table" option is the one that most closely matches what was in SL 2011.  I believe this was created by design and will not be changed.  Is it possible for you to change the way your users access the database?

  • Community Member Profile Picture
    Community Member on at

    Hi Adam, Jeremy, did you resolved this issue?, Can you tell me how?. I have the same situation.

    Thanks in advance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans