General information
Forum:
Microsoft SQL Server
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only