|
-
Sep 24th, 2003, 01:05 PM
#1
Thread Starter
Hyperactive Member
Ex of select from text file/recset
Brucevde was really helpful in supplying the code *below* to create a recordset and write it to a text file. Can you read the recset from the text file in such a way as to "select" from the file?
For example, I want to get a new recordset from the saved file containing rows whose "Record" field is > 2.
Here's the code I'm working with to write the text file:
Set rs = New ADODB.Recordset
With rs
.Fields.Append "Record", adInteger
.Fields.Append "Description", adChar, 30
.Open
For lCt = 1 to 3
.AddNew
.Fields("Record").Value = lCt
.Fields("Description").Value = "Description for Record " & str(lCt)
Next
.Save "c:\temp\rs.txt", adPersistADTG
.Close
End With
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|