how to export data to text file without coma

[Sunny]

Hi all,

This question may have been asked many times, but I can't find the exact
answer what I want. I want to export all data to text file programatically
without delimited or coma. I dont need header and I dont want to use schema
since everytime table will be different.

Table : Emplyee
EmpId Name Department
1 John Smith Sales
2 Mary Kate Customer service
3 Jessie McDonald Packing

End result should be:

1 John Smith Sale
2 Mary kate Customer Service
3 Jessie McDonald Packing

I think I can do select * into (Text;Database=C:\temp\Test.txt) from
mytable. This works but it exports with Heading and commas between fields.

Can anyone please help.

Thanks.

 

[Fred]

If there is nothing separating those items then you are no longer treating
the as separate fields.....so you can just concantate them in a query.