VB Forum / Database Access / February 2005

Hello!

I want to do a batch query reading the criteria from a text file.  The query
should return in one recordset, and the result will be saved in another text
file.  I'm using array to read the input file, but it returns in more then
one recordsets... then the output file turns out to has only one record (the
last value in the input file).  

Here's my code:        
       ConnSRdb  'connect to db
       
       Dim qFile As String
       qFile = txtSearchbyBatch.Text
       Dim sField
       Open qFile For Input As #2
       
       Dim sData() As String
       Dim Count As Integer
       Count = 0
       
       Do While Not EOF(2)
           Input #2, sField
           ReDim Preserve sData(Count)
           sData(Count) = sField
           CommandText = "select mslink, slope_no, status, reg_date from
slp_feature where " & _
           "" & cboSearchby2.Text & " = '" & sData(Count) & "'"
           Set queryRs = sdoConn.Execute(CommandText)
           Count = Count + 1
       Loop
       Exportcsv queryRs, exportPath  'save result into a text file.
       Close #2

Can anyone tell me how to put all results into one recordset?

Thanks!
Kate