> It was a pleasure. I don't know anything about web stuff, but I do > know importing CSV files as I do it all the time. Seldom do I get to > answer a DP question, so this was fun for me.
Hi Charlie; I'm in the same boat as you. Although I've been doing databases in DP with intricate reports for more than 25 customers, I know nothing about web stuff. The funny thing is that throughout my over 20 years of DP experience, I never had to import Excel files. I really appreciate this marvelous group who are there for each other in time of need. Thanks once again and all the best Malkie > > Take care. > Charlie > > > [email protected] wrote: > 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 > > > > [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 > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
