title: Delphi 7, TTable, Csv file fields
body: <p>HI,
  My Question may be a simple one for you. </p>
  
  <p>I have to import a csv file to my delphi application. This file contains 3 columns and I want to match the columns to one of Dataset( TQuery connected to a Firebird table) and show on a grid.</p>
  
  <p>My Question is, is it possible to use the Csv file as a table, who can access by a SQL query and join to a Db table ?</p>
  
  <p>I have tried with TTable with TableType property as ttASCII. It loads the file.However this loads the contents to a single fields,
  ie, Fields[0].asstring gives '11,12,abc.txt'
  I want this on different fields
  ie, 
  Fields[0].asstring = '11'
  Fields[1].asstring = '12'
  Fields[3].asstring = 'abc.txt'</p>
  
  <p>Hope you understand my requirement. Kindly take a look and let me know your thoughts</p>
  
  <p>Thanks and Regards,</p>
  
  <p>Vijesh V.Nair</p>
  
  <p>System Analyst</p>