Thank you Tom, Charles, Tony and Don for your
quick responses and assistance.
Charles, your clear instruction of "For the
Record Delimiter, press the space bar" was the solution. I pressed
[Enter] for the Record Delimiter instead of the space bar. I didn't
realize that the "~" was a problem.
Thanks Tom, for your suggestion too of just
replacing the "~" with a space before the
<CR><LF>. Both ideas work beautifully.
DataPerfect rocks!!! There's nothing like it!
I can't wait for DP for Windows version to appear.
Tom and Don, you're right. Only .csv files
can be imported.
Don, I work with Excel files a lot but only
exporting from DP. I never tried importing. I knew to remove the commas
in the Excel file before saving it as a .csv file, since .csv is comma
delimited.
Tom, while I was trying to figure out the
problem, I was thinking of your idea of exporting it as a .txt file and
importing it into DP via WP but I was sure there was an easier way
around it. So I wrote to this wonderful group of expertise and voila!
in no time I got help.
Thank you all so much and have a great day!
Malkie
>
> 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
>
>
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
