Hi Ric,

In DTS you can select query as the source. In the query you can use CAST function to convert binary fields into character fields.



>>DId you try DTS?
>>
>>>I am not a SQL guru, but I really need some help. How do I export from SQL into a format that convers binary data to some sort of readable data in Excel? I have tried from Excel using a DNS to get data from the SQL database, but the results always leave out the columns with binary data.
>>>
>>>TIA
>>>
>>>Ric
>
>Hiya, and thanks for the replies.... Yes, I have tried DTS. The problem appears to be when I am 'pulling' from Excel, regardless of source. I am thinking there is some unknown-to-me-SQL-binary-field-capture rule which allows for the capture rule or something...
>
>As to the row rule, are you talking regarding the number of data items? I am only trying to capture 200 or so rows.
>
>Tic