Bingo! That does the trick. But if I wanted to change the fields returned would I muck up the DataSet object?
Glenn

>>I am trying to change the SQL statement of an OleDbAdapter on a Vb.Net Winform program as I would a SQL pass-thru. I have tried to change the .SelectCommand.SelectText, but I am not very successful with this approach. Is this allowed and if not how can I dynamically Fill a DataSet object?<
>
>Glenn,
>
>You need to change the SqlCommand.CommandText (I think that's the right object, I don't have .NET loaded on this PC, so this is off the top of my head). Try it and see if that takes care of it. If not, maybe you could post the code that doesn't seem to be working.
>
>~~Bonnie