|
Well, you notice I am hedging my comments, right? Its been awhile since I did it, but I remember that making each field a text field (with apostrophes) solved a lot of my problems. --------------------------------- Booth Martin http://www.martinvt.com --------------------------------- -------Original Message------- From: Midrange Systems Technical Discussion Date: 06/15/05 14:20:52 To: midrange-l@xxxxxxxxxxxx Subject: Re: String and field delimeters when doing a CPYTOIMPF Martin, Not recently but I vaguely remember having some trouble with Excel loading the data but on second thought that might have been embedded CR/LF. Paul -- Paul Morgan Senior Programmer Analyst - Retail J. Jill Group 100 Birch Pond Drive, PO Box 2009 Tilton, NH 03276-2009 Phone: (603) 266-2117 Fax: (603) 266-2333 Martin wrote >Have you tried it? My experience is that the only time you will have a >problem is when you have an embedded apostrophe-comma-apostrophe (no blanks) -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. .
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.