Count Recordset in Access DB and report to XL

  • I am not familiar at all with connecting to an Access DB from Excel VBA. My task is to retrieve the number of records for each table a, b, and c from XYZ.mdb and update cells A1:A3 with the respective values. My project entails a bit more but I am fairly certain with this issue address I should be able to handle the rest. Thank you.

    DaCat1997:catinthe:
    San Antonio, Tx

  • Re: Count Recordset in Access DB and report to XL


    Thank you Andy for pointing out that previous post. It did not come up with my search. It worked perfectly. Thanks again. :rock:

    DaCat1997:catinthe:
    San Antonio, Tx