Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    4

    Unanswered: Copying data between two databases

    Hi All

    I have a database that i wish to populate with data from another password protected access database. I have created a form and with a text field so that the user can enter the code of the record they want to import into the database. I am struggling if I should use ADO or DAO or some other method and what the best way to bring the data accross is. The table structure will be the same in both databases.

    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    your's is not a real DAO vs ADO question.
    the DAO model is "obsolete" (ha!!), but is more completely implemented than the ADO model is today (or ever will be).
    both models can handle the problem in various ways, but probably the best is independent of either model: transferdatabase ...see help

    izy
    currently using SS 2008R2

Posting Permissions

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