Advice System Automatic Visual Fox Pro

[pgalvezt]

Hello, Always I have worked ander Oracle Sql Systems and for me I Have learned how left the system automaticaly with direct connections (ODBC)

But now is the first time that I working with bases dbf (Visual Fox Pro). So the bases are going to be in different folders for example:

Year Folder: 2012

     Month Folder: Ene,Feb Mar and so on

          Folder Code: TR,FY,HF,UJ

            TR: A.dbf

                  B.dff    

                  C.dbf and so on the same thing with the others folders (TR,FY HF,UJ)

Actually Im connected using: See the attached file please.

The idea with to put "Sites" is emulate the Concatenate Function. And the sentence For (The idea is create a Qvd by period).

This connection is manual. I need some advice if anyone has worked with this before. The idea is that works automaticaly.

The connection is throught from OLE DB (Connector Visual Fox Pro).

If you need more details please let me know.

Thank you. 

[pgalvezt]

Any Advice?

Thanks