Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help Please!!
Message
From
22/09/2002 16:51:39
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Miscellaneous
Thread ID:
00701530
Message ID:
00703191
Views:
14
>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
Map
View

Click here to load this message in the networking platform