0 Replies Latest reply: Mar 9, 2010 4:50 PM by hngo2000 RSS

    Loading excel data into QVD files

    hngo2000

      Please advise as to what is wrong with this script below. Thank you.

       

       

       

       

       



       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       





       

       

       

       

       



       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       





       

       

       

       

       



       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       



       

      NetworkAttacksDB:

      LOAD

       

       

       

      // No.,

       

       

      [Filter No.]

      ,

      [Filter Name]

       

       

      ,

      [Source IP Address]

       

       

      ,

      [Dest IP Address]

       

       

      ,

      Action

       

       

      ,

      Severity

       

       

      ,

      Hits

       

       

      ,

      Date

       

       

      (AddMonths(today(), -1)) as

      EntryDate

      FROM

      [G:\IT Security\KPIs\Network Attacks.xlsx]

      (

       

      ooxml, embedded labels, table is [Network Attacks]

      )

      WHERE

       

       

      FileTime([G:\IT Security\KPIs\Network Attacks.xlsx]) >= #$(LastExecTime)

      #

      AND

       

       

      FileTime([G:\IT Security\KPIs\Network Attacks.xlsx]) < #$(BeginningThisExecTime)

      #;

      Concatenate

       

       

      LOAD * FROM

      SecurityKPIs.qvd;

      Store

       

       

      NetworkAttacksDB INTO

      SecurityKPIs.qvd;