Access and CSVDE (Access 2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote