SW inventory

Brooke Justice

unread,

Jun 22, 2004, 3:55:08 PM6/22/04

to

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

John Vinson

unread,

Jun 22, 2004, 10:55:20 PM6/22/04

to

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Brooke Justice

unread,

Jun 23, 2004, 10:15:35 AM6/23/04

to

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

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:l7shd0h2kb701ahsh...@4ax.com...

John Vinson

unread,

Jul 5, 2004, 1:57:04 PM7/5/04

to

On Wed, 23 Jun 2004 09:15:35 -0500, "Brooke Justice"
<xbjus...@xequibrandx.com> wrote:

>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?

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>

Brooke Justice

unread,

Jul 6, 2004, 11:01:12 AM7/6/04

to

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

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message

news:ch5je0h7c6q0ecrbg...@4ax.com...

John Vinson

unread,

Jul 6, 2004, 6:05:28 PM7/6/04

to

On Tue, 6 Jul 2004 10:01:12 -0500, "Brooke Justice"
<xbjus...@xequibrandx.com> wrote:

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

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

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

Brooke Justice

unread,

Jul 8, 2004, 3:48:30 PM7/8/04

to

Thanks, I appreciate the info - especially the definition of p&e...... ;-)

"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message

news:4g8me0hp9qrchem7j...@4ax.com...