How can I export server log files into a Access 2003 table/query?

S

Sal Mal

I am trying to make an automated monitoring tool for my IT staff to view. The
server I need to query has two files that need to be recorded daily, a db
dump and a transaction dump. I want to make each of these entries be
automated so it sends this information to a Access 2003 table and then a
report can be generated from there.

Any assistance would be greatly appericated
 
J

Jeff Boyce

You don't indicate the source application for these logs.

You seem to be trying to force data into Access from outside -- would you
also consider using Access to pull data in?

Jeff Boyce
<Access MVP>
 
S

Sal Mal

They are just text based log files on a sybase server. I am not apposed to
have Access pull in this data.

Thank you for your prompt reply

Sal
 
J

Jeff Boyce

Are you saying that your sybase server generates xxxx.txt files for the
logs?

If so, open Access, use File | Get External Data | Import to pull in a copy
of the file. If you only need to link to it, use that choice instead of
Import.

Good luck

Jeff Boyce
<Access MVP>
 
Top