Information générale
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement