link an sql table to excel

Post the command string here. To get the command string, Go to Data -> Connections and select the connection. Then select Properties. On the second tab you will see two boxes: on has the connection string: this tell Excel what data source you are using. The second box is the command string, and this should reflect the SQL you are using. Select all the text in this box and paste it here.

Then tell me which one of the fields you want to filter on and the nature of the data (date, string whatever) and what the valid values can be.

I have a system that rewrites the command string "on the fly." It's simple VBA and an Excel Table that contains the SQL.

I'm making you do the exercise above so you can understand the concept on which the code is based. If you attach an actual workbook, I can show you how it is done using your own data - well, your own data structure. Clearly I do not have access to your data. I can do the coding without it, I just can't test it.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.