I have a file with This type of record
1,C0AAA006,"AAA MOBILE STORAGE(ON)",,,,,,,,,,,,0001,,,,,,
Now I have this following code
Do
recs = File.ReadText(-3)
SplitRecs= Split(recs,",")
NoQuotes = Split(def(2),"""")
i = i+1
txtrecords.Text = i
cmd="INSERT OR REPLACE INTO ""NameDB"" VALUES( """ & SplitRecs(1) &
""",""" & NoQuotes(1) &""")"
showstatus SplitRecs(1) & " - " & NoQuotes(1)
It takes a while for the file to get read in (About 5 minutes to read 1000
records :s)
Is there a way that I can get File.ReadText or some other way to only read the
first 3 piece of data after the comma's... 1,C0AAA006,"AAA MOBILE
STORAGE(ON)"???...instead of the entire line. I think that may speed up the
searching. This file has about 30,000 records.
OR is there another way I can get that data from a file read into the SQL lite
database?
--
You received this message because you are subscribed to the Google Groups
"nsb-ce" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nsb-ce?hl=en.
