import

[Kenneth Brody]

Quoting Steven Waters (Tue, 10 Jan 2006 07:49:21 -0800):

> Because the data has "," in the description fields
> some data is surrounded by quotes or commas for example
> a description might be like this,
>
> "valve",for ,"A/C 100-8"
>
> my data runs all over the place. That's why I was wondering if you can
> get excel to export not csv but tsv as in "~"
> thanks for the mid advice
[...]

Excel's "space delimited" format is not a delimited file, despite
Microsoft's poor name choice.  Rather, it's "space padded" into
fixed-length fields.  (Except for the last field, which has trailing
spaces stripped, so it's not a fixed-length file.)  As far as any
import routine is concerned, there is but one long field with CRLF
at the end of each line.  You would have to use MID() to pull out
each field from within the line.

However, why not use Excel's tab-delimited export?  (f=9 r=\n)

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com