[AccessD] TransferText wierdness

The odd thing is that I am doing this for 17 completely different files.  Each file has similar 
kinds of data, but the first 10 files work fine, the 11th doesn't.  I didn't even realize that I had 
a problem until I suddenly noticed that the imported file was missing some data (field label data) 
that was down several rows that the client referred to.

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> Well, all I can say is it's been that way as long as I recall. It
> assumes that whatever kind of value is in the first row, that's the
> datatype for the column, assuming it can figure out how many columns it
> 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.
> 
> Charlotte