SW inventory

  • Thread starter Thread starter Brooke Justice
  • Start date Start date
B

Brooke Justice

I've got several text files that all have the same column names and format.
However, they will vary in name and number. How do I go about getting that
data into a database in order to run queries against it? This is actually
output from a command that runs a software inventory on my computers. It
then puts the resulting file (named with the computer name) in a share.

Thank you,
Brooke Justice
 
I've got several text files that all have the same column names and format.
However, they will vary in name and number. How do I go about getting that
data into a database in order to run queries against it? This is actually
output from a command that runs a software inventory on my computers. It
then puts the resulting file (named with the computer name) in a share.

Thank you,
Brooke Justice
Click to expand...

I'd suggest creating a table in an Access database with matching
fields, and then using File... Get External Data... Import to import
the textfiles into this table.
 
Thanks. I have another question ..... There isn't anything in the data of
the file to specify what computer it's from, but the name of the file is the
computername. How would I get that into the table, besides manually sticking
it in there for every row?

Thanks,
Brooke
 
Thanks. I have another question ..... There isn't anything in the data of
the file to specify what computer it's from, but the name of the file is the
computername. How would I get that into the table, besides manually sticking
it in there for every row?
Click to expand...

Brooke, I was quite remiss in not getting back to you on this question
- did you get it resolved?

<p&e, if I unspamtrapped you correctly>
 
Thanks, I appreciate you getting in touch with me..... I have not gotten it
resolved - been kinda swamped with other things anyway.... I kinda figure
I'll have to stumble my way through a macro to import these with the part of
the filename that represents the computername, since the computername is not
part of the data in the files. If you have any suggestions that would be
great. I did finally remember about MS's Software Inventory Analyzer (MSIA),
and the new version works great for MS products, but of course an inventory
for all installed software is what is needed. I've got the data, I just need
it in some sort of workable format.....

By the way, thanks and yes you did, and what is "p&e"???

Thanks,
Brooke Justice
 
By the way, thanks and yes you did, and what is "p&e"???
Click to expand...

Sorry... usenetism for "Posted and Emailed".

A Macro won't cut it I fear, you'll need some VBA code I suspect.
 
Back
Top