title: Using TADOQuery result in another query?
body: <p>Using Delphi 2009. I have a TADOConnection to folder containing a csv file and a TADOQuery that pulls data from a csv file in there (Call it TADOQueryCSV). That works OK. </p>
  
  <p>I also have a second TADOConnection to an Access database with a table called AccessTbl_TEMP and various TADOQueries that process data in there. They work OK.</p>
  
  <p>Now I want to process the data returned by the TADOQueryCSV and insert it into the table in the Access database. But how do I refer to the data returned from the csv file.?</p>
  
  <p>I need something like this but don't know how to write the FROM clause.</p>
  
  <p>INSERT INTO AccessTbl_TEMP ( Field1,Field2 )
  SELECT csvField1, csvField2
  FROM
  TADOQueryCSV;</p>