Thanks guys, Richard: The reason i didn't mention the software is because all guis just create the text commands anyway so they all do the same thing. I doubt it is a problem with the gui i used which was "SQLite database browser".
Chris: Thanks for that but i dont know how that helps me. Are you suggesting that i write a script that inserts one word at a time to avoid crashing or was it just an example? How would i write a command that would import from a text file without the gui? Is it the .import command? Any more help would be great. Here is a small sample of the file that i am trying to insert: AA AAH AAHED AAHING AAHS AAL AALII AALIIS AALS AARDVARK AARDVARKS AARDWOLF AARDWOLVES AARGH AARRGH AARRGHH AAS AASVOGEL AASVOGELS AB ABA ABACA ABACAS ABACI ABACK ABACTERIAL ABACUS ABACUSES ABAFT ABAKA ABAKAS ABALONE ABALONES ABAMP ABAMPERE ABAMPERES ABAMPS ABANDON ABANDONED ABANDONER ABANDONERS ABANDONING ABANDONMENT ABANDONMENTS ABANDONS ABAPICAL ABAS ABASE ABASED ABASEDLY ABASEMENT ABASEMENTS ABASER ABASERS ABASES ABASH ABASHED ABASHEDLY ABASHES ABASHING ABASHMENT ABASHMENTS ABASIA ABASIAS ABASING ABATABLE ABATE ABATED ABATEMENT ABATEMENTS ABATER ABATERS ABATES ABATING ABATIS ABATISES ABATOR ABATORS ABATTIS ABATTISES ABATTOIR ABATTOIRS ABAXIAL ABAXILE ABAYA ABAYAS ABBA ABBACIES ABBACY ABBAS ABBATIAL ABBE ABBES ABBESS ABBESSES ABBEY ABBEYS ABBOT ABBOTCIES ABBOTCY ABBOTS ABBOTSHIP ABBOTSHIPS ABBREVIATE ABBREVIATED ABBREVIATES ABBREVIATING ABBREVIATION ABBREVIATIONS ABBREVIATOR ABBREVIATORS ABCOULOMB ABCOULOMBS ABDICABLE ABDICATE ABDICATED ABDICATES ABDICATING ABDICATION ABDICATIONS ABDICATOR ABDICATORS ABDOMEN ABDOMENS ABDOMINA ABDOMINAL ABDOMINALLY ABDOMINALS ABDUCE ABDUCED ABDUCENS ABDUCENT ABDUCENTES ABDUCES ABDUCING ABDUCT ABDUCTED ABDUCTEE ABDUCTEES ABDUCTING ABDUCTION ABDUCTIONS ABDUCTOR ABDUCTORES ABDUCTORS ABDUCTS ABEAM ABECEDARIAN Thanks :) -- View this message in context: http://www.nabble.com/Sqlite-crashes-when-i-imort-huge-list-t1842991.html#a5034321 Sent from the SQLite forum at Nabble.com.