It is sometimes easy, and sometimes very difficult. You need to save xls as CSV file and then import using a comma for field and hard return for record delimiter.
Now, when you do the hard return, it DP puts a "~" <CR><LF>. You need to go back and reenter a space before the ~<CR><LF> -- in place of the ~ . If that doesn't work for you, export xls as tab delimited txt file. Open Shell editor and replace hard returns with Control E hard returns, replace tabs with Control R carriage returns and then capture to your WP Shell clipboard and import clipboard to DP. I use Shell 3.1 so Shell4 may be a bit different. Or, if data isn't confidential, send me the file and str and I'll do it for you. Tom ut [email protected] wrote: >Hi Everyone! > >Perhaps one of you out there can help me. > >I'm trying to IMPORT Excel (xls or csv) (comma delimited) files into >DataPerfect. I thought it would be as simple as exporting a DP >datafile into Excel, but apparently it's not. > >In the DP import screen, I selected DOS Delimited Text, with a >"comma" for the Field Delimiter and "CR-LF" for the Record >Delimiter, but it doesn't work. Any suggestion? > >Malkie >_______________________________________________ >Dataperf mailing list >[email protected] >http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
