# a question on data import and export from kdb

**URL:** https://forum.kx.com/t/a-question-on-data-import-and-export-from-kdb/7364
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [October 30, 2011, 4:30am UTC](https://forum.kx.com/t/a-question-on-data-import-and-export-from-kdb/7364 "2011-10-30T04:30:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![csxpeng](https://avatars.discourse-cdn.com/v4/letter/c/8491ac/32.png) [@csxpeng](https://forum.kx.com/u/csxpeng)
#### Post date: [October 30, 2011, 4:30am UTC](https://forum.kx.com/t/a-question-on-data-import-and-export-from-kdb/7364/1 "2011-10-30T04:30:00Z")

</div>

Hi all,

Do you know if there’s any quick way to save the data from KDB to a file, for example, to a csv file? And any other way to import some data to KDB quickly instead of calling q-sql insert one by one? Appreciate your response.

Thanks and regards,

Sean

---

<div class="post-metadata">

### Author: ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)
#### Post date: [October 30, 2011, 5:34pm UTC](https://forum.kx.com/t/a-question-on-data-import-and-export-from-kdb/7364/2 "2011-10-30T17:34:00Z")

</div>

https://code.kx.com/trac/wiki/Reference/save

https://code.kx.com/trac/wiki/Reference/ZeroColon

https://code.kx.com/trac/wiki/Cookbook/LoadingFromLargeFiles

---

<div class="post-metadata">

### Author: ![csxpeng](https://avatars.discourse-cdn.com/v4/letter/c/8491ac/32.png) [@csxpeng](https://forum.kx.com/u/csxpeng)
#### Post date: [October 30, 2011, 5:40pm UTC](https://forum.kx.com/t/a-question-on-data-import-and-export-from-kdb/7364/3 "2011-10-30T17:40:00Z")

</div>

Thanks Charles. I should have gone through all the wiki pages before posting here.