1 2 Previous Next 17 Replies Latest reply on Aug 18, 2016 6:34 AM by Marwim Go to original post
      • 15. Re: insert records from excel sheet
        odie_63

        user8969537 wrote:

         

        Hi,

         

        Yes i would like to automate it, but the data records wont be same

        using .XLSX.

         

        For example :

         

        https://odieweblog.wordpress.com/2016/06/21/reading-an-excel-file-xlsx-as-an-external-table/

         

        SQL> select t.*
          2  from table(
          3         ExcelTable.getRows(
          4           ExcelTable.getFile('TMP_DIR','ooxdata3.xlsx')
          5         , 'DataSource'
          6         , ' "SRNO"    number
          7           , "NAME"    varchar2(10)
          8           , "VAL"     number
          9           , "DT"      date
         10           , "SPARE1"  varchar2(6)
         11           , "SPARE2"  varchar2(6)'
         12         , 'A2'
         13         )
         14       ) t
         15  ;
        
              SRNO NAME              VAL DT                  SPARE1 SPARE2
        ---------- ---------- ---------- ------------------- ------ ------
                 1 LINE-00001 66916.2986 13/10/1923 11:45:52
                 2 LINE-00002 96701.3427 05/09/1906 10:12:35
                 3 LINE-00003 68778.8698 23/01/1911 09:26:22        OK
                 4 LINE-00004  95110.028 03/05/1907 13:52:30        OK
                 5 LINE-00005 62561.5708 04/04/1927 18:10:39
                 6 LINE-00006 28677.1166 11/07/1923 15:10:59        OK
                 7 LINE-00007 16141.0202 20/11/1902 02:02:24
                 8 LINE-00008 80362.6256 19/09/1910 14:06:42
                 9 LINE-00009 10384.1973 16/07/1902 04:54:12
                10 LINE-00010  5266.9097 08/08/1921 11:51:34
                11 LINE-00011 12513.0679 01/07/1908 21:53:55
                12 LINE-00012 66596.9707 22/03/1913 05:20:10
        
        ...
        
                95 LINE-00095 96274.2193 08/04/1914 22:48:31
                96 LINE-00096  29783.146 06/04/1915 23:49:23
                97 LINE-00097 19857.7661 16/02/1909 21:21:52
                98 LINE-00098 19504.3969 05/12/1917 01:56:05
                99 LINE-00099 98675.8673 05/06/1906 17:41:10
               100 LINE-00100 24288.2885 22/07/1920 13:25:59
        
        100 rows selected.
        
        • 16. Re: insert records from excel sheet
          user8969537

          Yes, will be different colum and depends on the user who request.

          i will try and update here, as i am busy with training. cant able to try all this solution at the moment.

           

          Thank you

           

          Regards

          Jay

          • 17. Re: insert records from excel sheet
            Marwim

            i will try and update here, as i am busy with training. cant able to try all this solution at the moment.

             

            No problem, we will still be there when you come back :-)

            1 2 Previous Next