[AccessD] TransferText wierdness

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.

  
-- 
Stuart

On 16 Jul 2009 at 13:22, Charlotte Foust wrote:

> has.  'Course it also depends on what kind of delimiter the text file
> uses.  Commas don't work as well as pipes, and spaces are ghastly.
>