Hi Vince,
A space delimited file has spaces as the delimiter. For example, here is a
comma delimited format:
Nancy, Davolio, Seattle, WA
A space delimited file would look like this:
Nancy Davolio Seattle WA
If you use the import wizard in Access, with the space as a delimiter in the
above case, then no problem. However, what about the following:
Nancy Davolio Seattle WA
or
Nancy Davolio Seattle WA
where you cannot count on the number of spaces to be constant? The
Excel import wizard can easily handle this situation. The Access import
wizard cannot.
Tom
___________________________________
:
Am I missing something? A space delimited file has no delimiters, all
records are the same length and the length of each field has to be
defined prior to importing...
___________________________________
:
Hi Kristie,
You're not missing anything. This option is simply not available in
Access. Your best bet may be to import into Excel first, and then use
the Excel file as a source of data to do the import into Access.
Tom
_____________________________________
:
I need to import a space delimited text file. In Excel there is the
option to treat consecutive delimiters as one, but I see no such
option on Access. Am I missing something?
Thanks
