0 Replies Latest reply: Jan 11, 2018 8:40 AM by Peter Gardner RSS

    Daily qvd files from ODBC

    Peter Gardner



      I have been searching these forums and others but have not been able to find what I'm looking for.

      Basically, I have a transactions DB and I want to extract and store data into daily qvd files. (one qvd per transaction date).


      I know how to connect to the DB. I know how to store a table into a qvd. What i dont know is how to loop through the DB and save a seperate qvd for each transaction date.


      I need to create a daily qvd file for each day from the last two years so the solution will need to loop through the DB table saving each days transactions under a seperate qvd.


      Any help would be greatly appreciated.