Control Compliance Suite

 View Only

  • 1.  CCS read csv file's contents then write the data to SQL table

    Posted Dec 02, 2014 01:03 PM

    Hello All,

    I'm not sure if this is possible but I'm looking to have CCS (v11 OR v10.5.1) read an existing .csv file (can be .txt or .xls if need be) then take the contents and import that into an existing SQL table.  There are the same columns in both the file and the table.

    Is this possible?

    Thanks in advance!

     

    Rick



  • 2.  RE: CCS read csv file's contents then write the data to SQL table

    Posted Jan 06, 2015 10:01 AM
    With v11 Queries (and in 10.5.1 RMS data collection queries)I know you can save/export results to a MS SQL database but I believe it creates a new table with its own unique ID - by default anyway. I would be interested to see/hear what others might know. I can think of quite a few things could use this for.