[AccessD] TransferText wierdness

Given a choice, I ask for pipe delimited.  Pipes just always work, and you never find them in data.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> I generally use Tabs as delimiters, it's sort of a standard that is easily generated.
> 
> It's one of the default SaveAs options in Excel for instance - but the implementation is brain 
> dead.  If you have a comma  anywhere in your data, Excel will wrap the Tab delimited fields 
> in quotes - even though you are not using comma delimiters. grrrrr!  
> (What's the odds that they've fixed that in v10, I bet they were too busy making the Ribbon 
> prettier!)
> 
> Space delimited is fine as long as it is used properly - it doesn't mean that every space is a 
> delimiter, it means that every field is padded with spaces so that a field is always a fixed 
> length and starts at a fixed column position.  That way you can use  MID$(FieldStartCol, 
> FieldLength) to extract fields.
> 
>