SQl Systax Error in My Excel

[diddi10]

Hello,
I am new to Excel,
I am working on Excel when i open my Excel sheet getting this error " Run-time error '1004' Sql Syntax Error"
When i click on debug showing error on below line
"Selection.QueryTable.refresh BackgroundQuery:=False"
Previously this Excel sheet works fine but now we are getting this error, looks like they upgrade the system.
Can you please tell me what could be the problem??

Is it a database problem or Excel problem..

Please please help me..

Thanks,

 

[chuckles1066]

Hello,
I am new to Excel,
I am working on Excel when i open my Excel sheet getting this error " Run-time error '1004' Sql Syntax Error"
When i click on debug showing error on below line
"Selection.QueryTable.refresh BackgroundQuery:=False"
Previously this Excel sheet works fine but now we are getting this error, looks like they upgrade the system.
Can you please tell me what could be the problem??

Is it a database problem or Excel problem..

Please please help me..

Thanks,

You need to post the SQL code that's causing the syntax error.

 

[diddi10]

Thanks For your reply..

Actually i am new to Excel development i dont know where the SQL code resides in Excel.

Can you suggest me Generally Database details and Query where they can store in Excel..

Thank you..