| Home > Forum Home > Automating Data Analysis Tasks > Send variables to MSQuery via entry in Excel cell range? > this might be the problem, try it | Share |
This might be the problem, try it
Excel Help for This Might Be The Problem, Try It in Automating Data Analysis Tasks
| Forum Topic | Login |
This Might Be The Problem, Try It | Rate this: (3/5 from 1 vote) |
 | this might be possible due to the way you write queries in macro for example "Select * from table where field = " & variable wont work because msquery expects single quotes for each value try "Select * from table where field = " & "'" & variable & "'" | |
| ~ | ||
| Posted by xluser on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for this might be the problem, try it in the Excel Business Solutions Directory |