Export
Mike Schwartz
mschw at athenet.net
Tue Jul 1 19:18:47 PDT 2008
> In MS's inimitable way, it screwed up the import
> by
> separating Jones Jr. (one field) in 2 columns. About 100 instances of
> this
> type. This messed up the rest of the data for that record.
>
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
What are you using for the delimiter between fields? Generally I use
the pipe "|" sign, but sometimes the tilde "~". If you use an "odd"
character like that, you should be able to import the files into Excel or
most other databases without ever seeing a "Jones Jr." error.
Mike Schwartz
More information about the Filepro-list
mailing list