extract data to text file

[axism]

Hi, I am trying to write a function to extract some columns from a table off my sql server to a text file. Can someone give me an example please? Thank you in advance.

 

[jbenson001]

Seems you could use DTS for this

 

[axism]

hi benson, thanks for replying. can you be more speceif? I am not good at programming. I was thinking of more like adding a function or macro in my mdb file to do so.

 

[jbenson001]

I am not familiar with Access. I assumed that you where using SQL Server since this is a SQL Server forum. Perhaps post your quetion in the Access forum.

 

[JayKusch]

you could also leverage BCP within your function.

Thanks

J. Kusch