• dwain.c (1/3/2013) Given the power of SAS, if you can ever make it work it sounds like the makings of a great article!

    Indeed, I believe it would be. I find it quite annoying to have to use the import wizard. Per the SAS documentation, not all of the 4 providers support SQL operations, so there is that issue. However, I tend to think that the way an ADO recordset handles the data access would be similar in nature to the way OPENROWSET would handle it. Of course, that is just my totally uninformed speculation. I'll keep plugging away at it, and if I do come up with a solution I'll certainly share the wealth. One problem is that you only get the providers by having SAS installed on your machine. Now, SAS does provide just the providers for free, but I have been unable to get them to work on my personal machine, where I don't have SAS installed.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.