Pulling Data from winaudit into access?

Diakatarnis · 14 Feb 2008 at 14:17

Heres the question

Is t possible to get Access to look at a file saved from winaudit and pull off information such as CPU, HDD, Ram etc? so i dont have to go through each machine and pull off the information manually and type it in?

you can save them as XML, HTML, PDF Tab Delimited etc?

Any ideas?

Thank you

neil_g · 14 Feb 2008 at 14:22

do people still use access?

err, in access 2007 you can get external data from xml if that helps?

CliffyG · 14 Feb 2008 at 14:36

There is a free app called ocsinventory which can get all sorts of info from a machine directly into access (think the new version may be web based but im sure the old one can be got somewhere).

Diakatarnis · 14 Feb 2008 at 16:07

I tried that ocs one, it requres a server to function

In access its picking up the field names as data so where it has:

Machine Name
Domain
CPU Speed

etc, its picking them up as data and the field name is "itemname1"

Im after some way of it reading those items as fields rather than data.

Any ideas? isthere some magical function or command in access to do this?