Exporting certain fields from a SQL table

[cheesey]

I have a SQL database whereby I need to extract certain fields from that table as a space formatted file not csv. This needs to be as a single click(procedure?)

I have looked at a number of scripts but all seem to relate to the exporting of csv files.

Is it therefore possible.

I'm new to SQL so please be gentle!

TIA

Cheesey

 

[FoFa]

Use DTS, you can specify the output format, plus the query to pull just the data you want.

 

[cheesey]

Use DTS, you can specify the output format, plus the query to pull just the data you want.

Thanks for the response.

Will I be able to set user defined criteria ie invoice date or invoice nr for example in a dialog box of some kind in my query??

 

[FoFa]

If you use a Access front end or something else. Remember SQL Server is a Database Engine, not an application development platform.

 

[cheesey]

once again thanks for the response.

If I use Access as the front end I can't figure out the way to arrive at a fixed space formatted. It needs to go onto my accounts system and the layout is split into various fields that amount including spaces to 256 bytes. The export file from SQL will not be in the same layout as what I want ie 1st field is 20 characters but my accounts package only uses the 1st 6/

I hope that I've explained myself

Is that not possible?

TIA

Cheesey