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