0 Replies Latest reply on Jul 27, 2006 2:30 AM by JohnGree

    excel query

      Hi i am trying to query a excel sheet but i am getting an error, i am not sure what is wrong with my code
      i am not sure what to have in the from clause

      could someone please help me

      <cfquery name="test" datasource="iluvphone">
      SELECT *
      FROM [CF$]
      IN 'D:\Websites\ilucrapl\InetPub\wwwroot\DB\phone.xls' 'EXCEL 5.0;'