Excel 2003 Database Query

D

DaveT

I am importing external data to a worksheet using a data base query. The
query is a union query in sql, not the design grid. How can I use parameters
as part of an sql statement? Can I use a "Like" operator with a wildcard (%)
in the parameter?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Embed the same Excel multiple times 0
Dealing with the error: unable to filter on excel hc home school 0
How to store a connection with parameters into a workbook 0
I can't run the paramters I need in Microsoft Query 1
Access Query to import from Sharepoint 0
Excel 2007 Data -- SQL Server proc or function with parameter 1
Import New Database Query (Union Query) in Spreadsheet 2

Top