title: Importing data from an XLS File using ADO and Delphi
body: <p>I want to import some data from an Excel file ( xls ) by using <code>TADOConnection</code> and <code>TADOTable</code>.</p>
  
  <p>I connect to file with no problem, but when i open <code>TADOTable</code> some fields have <code>ftFloat</code> datatype because their values in excel file are numeric, but their values are not a number!</p>
  
  <p>I want all fields of <code>TADOTable</code> (columns of Excel file) to have <code>ftString</code> datatype.</p>
  
  <p>I set the types of columms in Excel file to <code>Text</code> but no changes affected!</p>
  
  <p>How can I do this?</p>