Tom, I just realized what might be going on. I struggled with the same thing a couple years ago and learned that if I wanted the load to be bullet-proof I had to massage the import file with a utility to search and replace troublesome text and replace the delimeter with a vertical bar '|'
No quotes - single or double No Parens No commas No Apostrophes The utility I use replaces these with null (deletes them). It's freeware and can be called from the command line (zip). Because spaces (yes, spaces) can also be a problem, before loading the file I set space to "~" and delimit to "|", since the delimeter is all that counts. Changing the space setting may solve the problem because they were being seen (or used) as a delimeter and mucking up my field order. This has worked flawlessly for a couple years a several sites. But I do get an occasional complaint that O'brian became Obrian :( Sorry I didn't think of this sooner. Ben Petersen On 20 Mar 2002, at 7:50, Tom Grimshaw wrote: > Many thanks to those who responded on the data loading question. > > Because most of us need to do it at some time I thought it > worth the time to report the results so it's feedback time > with a question at the end. > > Thanks for the suggestion Alastair, I altered the plus signs to > ampersands and it made no difference, R:BASE still didn't want > to play ball. > > I used the new LOAD tablename FROM filename.txt AS CSV with 6.5++ > and it worked, only if the text strings were enclosed in single > quotes then the single quotes were imported with the data. > (Found that out by accident, didn't I.) So don't do that. > > I then removed the single quotes from around the text fields and > "just for fun" inserted an apostrophe in the surname of the last > record I was importing, did a test with the AS CSV and crashed to > the desktop with the message: > > "RBG65.exe has generated errors and will be closed by Windows." > > This was not due to an error in my import data, this particular > import routine must use memory in a way that is not released as > it has been prone to crashes after successful imports.!@#$ > > How do some of you get to 40,000 rows before a crash and burn? > I can't get past 8! (Must be the water in the wrong direction > thing again.) > > On restarting R:BASE and checking the table all the data had been > imported. > > As the record with the apostrophe was the last in the record set > I duplicated the first rows without the apostrophe, altered the > PK values and retried the import - successfully. > > This is the record set that worked: > > 10002,,Sharron,.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 20002,,Jyo,Aadarsh,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 30002,,Bryan,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 40002,,Nigel,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 50002,,Stephen,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 60002,,Nicole,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 70002,,Rose,Abboud,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 80002,,Varant,A'boulian,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 10003,,Sharron,.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 20003,,Jyo,Aadarsh,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 30003,,Bryan,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 40003,,Nigel,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 50003,,Stephen,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 60003,,Nicole,Abbott,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > 70003,,Rose,Abboud,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > > Q. I still don't know how to get it reliable so it does not crash. > I would try a disconnect after importing the data for each table > only the import of data into successive tables is governed by a > complex form and disconnecting within an eep called from a form > is not an option. Any ideas? > > OK, just answered my own question, I'll try a loop, closing the > form after an import and looping to the top of the code and just > reopening the same form. > > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files transmitted with > it are free from such viruses. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
