Next try - 1. Have you tried setting your date format and sequence to the *exact* format in the import data?
2. I have had some success importing data into one large text field, then parsing it out after import. Create a table that is one large text field more than adequate to contain the whole row of data in the external file. Use the LOAD AS FORMATTED command. CREATE TEMP TABLE ImportTable (ImportCol TEXT (500)) LOAD ImportTable FROM filename.txt AS FORMATTED USING ImportCol 1 500 INSERT INTO RealTable ( Col1, Col2, Col3, ...) + SELECT (SGET(ImportCol,n,n)), ... FROM ImportTable --- [EMAIL PROTECTED] wrote: > Thanks Albert - That's the first thing I checked. > > > > > Albert Berry <[EMAIL PROTECTED]> > Sent by: [email protected] > 07/12/2005 08:27 PM > Please respond to > [email protected] > > > To > [email protected] (RBG7-L Mailing List) > cc > > Subject > [RBG7-L] - Re: Access Violation Error Message > > > > > > > Make sure that > > 1. ALL variables are declared and typed outside the loop. > > 2. NO variables are retyped or cleared inside the loop. > > > --- [EMAIL PROTECTED] wrote: > > > > > RBase 7.1.81.30707 > > Whileopt off > > Using launch to go to third party text conversion application > > Using Gateway Import.... to import a text file into rbase. > > Windows 2003 Server - .rb? files > > Windows XP - Rbase > > Both Microsoft products patched to todays patches > > > > > > I am importing a large number of text files 30K+. I use two nested wile > > loops. The application runs fine for a few hundred to a few thousand > text > > files and then either hangs, or hangs with a "Access Violation At > Address > > 01059108 in RBENGINE.DLL Read of Address 07632000. This process will not > > run with Whileopt on. I receive a error when it tries to write the > record > > that has a date in it. Does anyone have any clues for me?? - Thanks > > > > > > > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] > > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
