Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ADO, DAO, I don't know (2002)

    I need to use either ADO or DAO, I think, but I'm not sure which is the best approach or maybe it doesn't even matter which one I use. I basically need to load some Access staging tables with data sourced from either a .csv file, excel spreadsheet, or another Access table. I'll then need to be able to loop through the stage tables, apply some business rules, and then populate a "production" table with the stage data that has passed the business rule validation. I don't see a need at this point to connect to any other RDBMS or data source. Based on what I've read, DAO would probably meet my needs, but I wanted to get some outside opinions. I'm looking for pros and cons of each approach, any insight to Microsoft's direction with DAO vs ADO, and any other advice anyone would like to share.

    Thanks in advance for any guidance.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ADO, DAO, I don't know (2002)

    Which model are you most comfortable with? And do you really need to do this in code or would a direct import into a staging table and then running update queries work just as well?
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: ADO, DAO, I don't know (2002)

    I don't think it would matter much. I'd say the final decision would probably be based on what you are more comfortable with. My understanding is that while Microsoft had long declared that ADO was replacing DAO, it seems like I read somewhere that DAO has made a "comeback" of sorts in Access2003. Apparent MS realized DAO was too useful to discard!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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