# Exporting BLOB Data

**URL:** <https://forums.toadworld.com/t/exporting-blob-data/34239>\
**Category:** Toad for IBM DB2\
**Created:** [October 5, 2015, 9:35pm UTC](https://forums.toadworld.com/t/exporting-blob-data/34239 "2015-10-05T21:35:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![slinki](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@slinki](https://forums.toadworld.com/u/slinki)\
**Post date:** [October 5, 2015, 9:35pm UTC](https://forums.toadworld.com/t/exporting-blob-data/34239/1 "2015-10-05T21:35:18Z")

</div>

Hi everyone,

I’m having difficulty to export \> 1 row of BLOB data into .csv file.

**The result set is appear and the export phase is completed, but the BLOB data column is missing.**

Anybody have the same experienced & would u please share with me how to solve?

Than you in advanced guys!

\*\* Version: Toad for DB2 Version 5.5

---

<div class="post-metadata">

**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\
**Post date:** [October 7, 2015, 4:28am UTC](https://forums.toadworld.com/t/exporting-blob-data/34239/2 "2015-10-07T04:28:17Z")

</div>

Hi slinki,

unfortunately Binary data types cannot be exported to CSV format. It is stated in Help | Work with Data | Export Data with the Export Wizard.

Have you tried exporting to different formats? Are you using export wizard or quick export?

Thanks,

---

<div class="post-metadata">

**Author:** ![slinki](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@slinki](https://forums.toadworld.com/u/slinki)\
**Post date:** [October 7, 2015, 11:37pm UTC](https://forums.toadworld.com/t/exporting-blob-data/34239/3 "2015-10-07T23:37:50Z")

</div>

Hi Daniel,

Thanks for your response.

Fyi, i’m using export wizard and have tried to export the file into .xls & .sql as well, but come up with same result.

So then, need to moving forward…tasks need to be done bhobc…yeah we’re trying another approach right now.

Thanks again Daniel. 🙂