DHCP export to MS Access

[agape234]

I want to export the MS DHCP DB and incorporate that into an existing MS Access DB. Under ideal conditions, I would use Perl/SNMP scripts to extract that data from my server and then export that into the Access DB, along with other information gathered via the same process. Any info would be helpful. I can see Scope statistics using SNMP but am unable to extract the entire db using that method.

 

[GlenJohnson]

Can you copy the dhcp table into a csv format, then import it into access. (Give the laziest man the hardest job, and he'll find the easiest way to do it.)

Glen A. Johnson
"Fall seven times, stand up eight."
Proverb

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[agape234]

I can copy the table into a csv, but it gives only the inividual scopes and not all the details (reservations, leases, properties etc). I ran the backup utility that Microsoft recommends and followed the steps. That produces a .mdb file. This will not open with MS Access.
I can also copy/paste data from the registry however, this is not the avenue method of choice.
Idealy I would like to SNMP the entire DB out to a csv and not have to do it in a bunch of steps.

Any thoughts?

 

[GlenJohnson]

Access won't open an .mdb file? Odd. Have you tried to use SQL and select data transformation? When you copy to a .csv, have you tried to open it in Excel? I've used this hundereds of times and it works great. Either option should work.

Glen A. Johnson
"Give the laziest man the hardest job and he'll find the easiest way to do it."

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884