Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access and CSVDE (Access 2003)

    I want to build in VBA the ability to use CSVDE to pull my Users and permissions into a table to establish a baseline and then from then on I want to pull the AD information and compare it to my baseline data and show exceptions in a list box.

    Has anyone got something like this already going or any ideas I currently am using excel for pulling the data by exporting it into a csv file then importing it into Excel. I think it would be much easier to manage in Access and to see if I have any unauthorized accounts if I had a baseline to compare the AD dump to.

    Anyone have anything??

    Dan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access and CSVDE (Access 2003)

    I don't know anything about CSVDE or AD.

    You can import or link .csv files in Access directly. If you import interactively through Files | Get External Data | Import..., you can store an import specification that you can use when importing/linking the data in VBA. The method used for this is DoCmd.TransferText. Type this in the Visual Basic Editor and press F1 to get help on TransferText.

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and CSVDE (Access 2003)

    Thanks Hans. I will get right on that. Do you have any suggestions in comparing the imported info against the baseline data? I was going to create a temp table for the newly imported data and compare it against the baseline table...but how do I do the comparison and get a list of the fields that arent in the baseline table??


    Dan

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

    Re: Access and CSVDE (Access 2003)

    Please clarify. Are you trying to compare fields, that is, table structure, or are you trying to compare data?
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and CSVDE (Access 2003)

    Sorry for the confusion ,

    What I want to do is compare the name field in the imported table against the name field in the baseline table and have any differences show in a list box on the form.

    Hope that is a bit clearer.

    Dan

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

    Re: Access and CSVDE (Access 2003)

    It sounds like you could use the Find Unmatched Query Wizard to create the query you need.
    Charlotte

Posting Permissions

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