Exporting binary data  
Author Message
RMSELTech





PostPosted: Fri Sep 02 13:04:40 CDT 2005 Top

SQL Server >> Exporting binary data

We're using MS-SQL Sever for a documentation database. One of the tables
stores all the DOC, XLS and PPT documents fed by our users.

We need to export all the files to certain directory and the rest of the
table contents to a spreadsheet. We want to distribute the documents in a
promotional CD.

The data export to a CSV works without a problem but we don't know how to
export the binary data of the files that are stored in the table. How can
this be done?

Thanks in advance,
JT

SQL Server166  
 
 
David





PostPosted: Fri Sep 02 13:04:40 CDT 2005 Top

SQL Server >> Exporting binary data
> We're using MS-SQL Sever for a documentation database. One of the
> tables stores all the DOC, XLS and PPT documents fed by our users.
>
> We need to export all the files to certain directory and the rest of
> the table contents to a spreadsheet. We want to distribute the
> documents in a promotional CD.
>
> The data export to a CSV works without a problem but we don't know
> how to export the binary data of the files that are stored in the
> table. How can this be done?
>
> Thanks in advance,
> JT

Please try not to multi-post. See ".Clients" for the current active
thread.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com