Home

SQL- Data populated in Query but return to Excel it doesn't, happen only to one user

%3CLINGO-SUB%20id%3D%22lingo-sub-687429%22%20slang%3D%22en-US%22%3ESQL-%20Data%20populated%20in%20Query%20but%20return%20to%20Excel%20it%20doesn't%2C%20happen%20only%20to%20one%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687429%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20pulling%20Comments%20column%20data%20from%20Job_chg%20table%2C%20SQL%20to%20Excel.%20The%20column%20data%20are%20populated%20to%20everyone%20else%20but%20there%20is%20only%20one%20user%20is%20experiencing%20that%20he%20the%20Comments%20column%20data%20doesn't%20populate%20data%20when%20he%20hits%20refresh%2C%20instead%20the%20Comments%20column%20in%20excel%20become%20blank.%20The%20weird%20thing%20is%20only%20him%20has%20this%20problem.%20Please%20see%20pictures%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-687429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687715%22%20slang%3D%22en-US%22%3ERe%3A%20SQL-%20Data%20populated%20in%20Query%20but%20return%20to%20Excel%20it%20doesn't%2C%20happen%20only%20to%20one%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687715%22%20slang%3D%22en-US%22%3EAre%20there%20any%20user%20rights%20implemented%20on%20the%20source%20database%20perhaps%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687780%22%20slang%3D%22en-US%22%3ERe%3A%20SQL-%20Data%20populated%20in%20Query%20but%20return%20to%20Excel%20it%20doesn't%2C%20happen%20only%20to%20one%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687780%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20user%20has%20full%20access%20to%20database.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hi Everyone,

 

I am pulling Comments column data from Job_chg table, SQL to Excel. The column data are populated to everyone else but there is only one user is experiencing that he the Comments column data doesn't populate data when he hits refresh, instead the Comments column in excel become blank. The weird thing is only him has this problem. Please see pictures attached.

 

Thank you in advance for your help.

 

 

2 Replies
Are there any user rights implemented on the source database perhaps?

Hi @Jan Karel Pieterse 

 

The user has full access to database.

 

Thank you

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies