| Home > Forum Home > Automating Data Analysis Tasks > Send variables to MSQuery via entry in Excel cell range? > SQL query text | Share |
SQL query text
Excel Help for Sql Query Text in Automating Data Analysis Tasks
| Forum Topic | Login |
Sql Query Text | Rate this: (3/5 from 1 vote) |
 | It could be something to do with the way that the query is built with the variable. I notice that you have Chr(10) in the SQL query and that the variable is not wrapped in single quotes. Have you tried to output the query text to a cell and then tried this directly within the database? | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for SQL query text in the Excel Business Solutions Directory |