>>Vinod,
>>
>>I assume that you have not had success with "...delimited with BLANK".
>>
>>Perhaps you could let us know what you have tried, rather than just what you got.
>>
>>regards,
>>Jim N
>>
>>>I want to Export Database to txt file, I want the output like this
>>>
>>>Field 1 Field 2 Field 3 Field 4
>>>xxx xxxxxxxx xx xxxx
>>>xx xxxxxx x xxx
>>>
>>>Copy to command either transfers it in this way :-
>>>
>>>xxx,"xxx",xxx
>>>
>>>or
>>>xxx "xxx" xx
>>>
>>>Pls Advs.
>
>I want SDF Format with spaces, I have tried copy to command all variations, export command
What I've done for your situation when nothing seems to work is to create an intermediary table in which you reformat the fields to exactly the way (length, etc) you want, and then copy...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.