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
Highlighted
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
Highlighted
Are there any user rights implemented on the source database perhaps?
Highlighted

Hi @Jan Karel Pieterse 

 

The user has full access to database.

 

Thank you