Excel 2013 Question re: Microsoft Query from SQL

T

txgeekgirl2

New Member
Joined
Apr 5, 2017
Messages
8
I am trying to set a query in Excel from Data\From Other Sources\From Microsoft Query - I am able to get the base data to load fine. The issue becomes when I am setting a parameter based on a Cell value. In this case C5.

gTVUGF


The cell has valid data in it. If I hard code 'SIR%' I get results. If I use the Parameter screen because I need the data to refresh when someone changes the value of C5, I get empty!

jNeObF
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

R
  • Solved
VBA Queries refresh and Save data as TXT
Replies
2
Views
102
Artik
Artik
T
  • Question Question
VBA to run when a table with a SQL query is refreshed?
Replies
0
Views
140
Tarver
T
B
  • Question Question
Table refresh removes Data Validation value from previous last row and pastes it to newly imported last row
Replies
0
Views
227
bdbilotta
B
L
  • Solved
Trouble running an access query in excel vba
Replies
2
Views
107
Legal Tender
L
M
  • Question Question
Passing SQL code to server and retrieve results
Replies
2
Views
359
Candyman8019
C

Forum statistics

Threads
1,223,230
Messages
6,170,883
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top