Results 1 to 3 of 3

Thread: Batch dump

  1. #1

    Batch dump

    Is there an easy way to batch dump a DB from an OBDC source to Access using VBA? I am looking for a syncronize facility of some sort that is built into ADO/SQL/DAO.

    I am using a line by line comparison program written in VBA but this seems a cumbersome way to do this. I guess I am looking for something similar to the BatchMove (?) utility available for SQL server.

    Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Batch dump

    You haven't given us enough information. What version of Access/ADO/DAO/SQL are you talking about? What ODBC source are you talking about? Do you want to synchronize a single table or a number of tables or what? What is the purpose of trying to compare the data in the source to what's in Access rather than just importing the data or using Access as a front end?

  3. #3

    Re: Batch dump

    I am using a SCADA software program (Wonderware) that talks to access. The OBDC source is Progress/MFG Pro and I dump the whole table (2000 records) to a local database. This make my SCADA application more robust since it is not affected by downtime of the OBDC source.

    I presently download the info using a script written in Wonderware which I want to move to a VBA app. The wonderware script at present only downloads a limited number of items using a filter based on some criteria since it is not very good at long processes. This causes syncronisation errors since records may have been deleted on the source.

    I have Access 2000 and VBA 6 with all the patches. I could write the software myself but I have learnt that using a pre-written solution is more robust, easier to use and normally many times faster since it is optimised.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts