# Can I use SQL to save a column of data to a text file?

**URL:** <https://forum.kirupa.com/t/can-i-use-sql-to-save-a-column-of-data-to-a-text-file/225710>\
**Category:** programming\
**Created:** [May 15, 2007, 2:50am UTC](https://forum.kirupa.com/t/can-i-use-sql-to-save-a-column-of-data-to-a-text-file/225710 "2007-05-15T02:50:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mr\_Paul\_Jones](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@Mr\_Paul\_Jones](https://forum.kirupa.com/u/Mr_Paul_Jones)\
**Post date:** [May 15, 2007, 2:50am UTC](https://forum.kirupa.com/t/can-i-use-sql-to-save-a-column-of-data-to-a-text-file/225710/1 "2007-05-15T02:50:21Z")

</div>

Basically I don’t want my msSQL database accessed directly through a website, mainly because I don’t want it working any harder than it should be.

I want to show specific statistics on my website that will be pulled from the database say once per day and saved to a text file that will be CALLed by the website.

I was thinking I have two options, create an SQL script or create an application to do it. SQL seems the most appropriate way.

What I ask is, is this possible? And can someone point me in the right direction?

Thanks 😛