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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>
 
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
 
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>
 
Back
Top