That was an interesting article but there is another way to go I use - which doesn't involve SSIS (which I don't have).
Basically, you can make a refreshable query table in the excel workbook. That will allow you to import your data and refresh as often as needed for free.
* First, open and excel workbook and go to Data>"From other Sources"
* In the "Data Connection Wizard" enter your server name and log on credentials as needed and click Next.
*Select the database you need in the top drop down,
*Select the table or view you would like to connect to below that,
You will then be asked where you would like to dump the data (select the cell you would like to have as the top-left corner of the returned record-set).
You can press enter at this point, and you now have a refreshable excel table that is populated from the table you have selected.
**Note: At this point, instead of pressing enter, you can click on Properties>Definition and you can change the "command type" from Table to SQL - that will let you paste a custom query right into the "command text". I've found that very helpful when I want to access a specific view with sorting.
You can also ask the workbook to Save the password (check the box) - this is handy when you want to distribute your creation around the office (if you are using SQL credentials)
Try it out - there is no problem with a maximum character count that I've run into -- I've never had a problem returning long strings from a varchar(max) or text type using this method. But the best part of this method is it's free and doesn't require you to have SSIS. 😀