Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Automating import of dynamic text file into MS Access

Discussion in 'Information Technology' started by FuzzyLogic, Jul 28, 2006.

  1. FuzzyLogic

    FuzzyLogic
    Expand Collapse
    Guest

    I've been doing Google searches for hours on this subject without
    finding exactly what I'm looking for, so before I settle for something
    different than what I really want to do, I figured I'd ask the
    experts...

    I'm taking it upon myself to set up a syslog server in a primarily
    Windows Server 2003 environment, using free software and scripts I've
    collected from the web (have no budget, this is just something we need
    and I'm tired of trying to convince people of that.) What I have so far
    is a syslog server that collects event log information from multiple
    Windows Server 2003 machines and dumps them into a
    continuously-updating text file. On a weekly basis, this text file is
    dumped to another directory on the syslog server as a text file with a
    time and date stamp.

    What I'd like to do is create an MS Access database wherein these text
    logs are automatically imported to give our IS department access (no
    pun intended) to the event logs using a versatile front end (MS
    Access.) Trouble is I have no MS Access experience, so I'm stumbling
    along. Cruising Google Groups, I've found out how to do an initial
    import of one of these text files using the Import Wizard, and how to
    set it up to columnize the data properly. Then I read how to create a
    macro to perform this function. Fantastic.

    One hitch...The macro is dependant upon a text filename that does not
    change. I've found that I can make the macro prompt a user for a
    filename to import, but I'd really like to make this hands-free if at
    all possible. Is there any possible way I can automatically import
    these text files into Access (using a macro, vbs, whatever) when the
    file name of each newly-created text file will change? For example, the
    first archived log file would be named "Syslog07-23-06.txt" but the
    next would be "Syslog07-30-06.txt", and so forth.

    Hopefully some of you will consider this a piece of cake, because it's
    way beyond me.

    Thanks,

    FL
     
  2. Loading...

    Similar Threads Forum Date
    Importance Of Dastar History of Sikhism Aug 12, 2016
    Importance Of Tirath / Pilgrimage As Per Gurbani Gurmat Vichaar Jun 1, 2016
    Superheroes: Arjan Bhullar Explains Wrestling's Importance In The Sikh Community Sports & Fitness Apr 15, 2016
    Important decisions in life Questions and Answers May 25, 2015
    Friendship Between Genders... Important Question Questions and Answers Dec 20, 2012

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Check Out DoCmd.TransferText

    Pieter

    "FuzzyLogic" <corey.robinson@knoxcommhosp.org> wrote in message
    news:1153934951.054751.179540@m79g2000cwm.googlegroups.com...
    > I've been doing Google searches for hours on this subject without
    > finding exactly what I'm looking for, so before I settle for something
    > different than what I really want to do, I figured I'd ask the
    > experts...
    >
    > I'm taking it upon myself to set up a syslog server in a primarily
    > Windows Server 2003 environment, using free software and scripts I've
    > collected from the web (have no budget, this is just something we need
    > and I'm tired of trying to convince people of that.) What I have so far
    > is a syslog server that collects event log information from multiple
    > Windows Server 2003 machines and dumps them into a
    > continuously-updating text file. On a weekly basis, this text file is
    > dumped to another directory on the syslog server as a text file with a
    > time and date stamp.
    >
    > What I'd like to do is create an MS Access database wherein these text
    > logs are automatically imported to give our IS department access (no
    > pun intended) to the event logs using a versatile front end (MS
    > Access.) Trouble is I have no MS Access experience, so I'm stumbling
    > along. Cruising Google Groups, I've found out how to do an initial
    > import of one of these text files using the Import Wizard, and how to
    > set it up to columnize the data properly. Then I read how to create a
    > macro to perform this function. Fantastic.
    >
    > One hitch...The macro is dependant upon a text filename that does not
    > change. I've found that I can make the macro prompt a user for a
    > filename to import, but I'd really like to make this hands-free if at
    > all possible. Is there any possible way I can automatically import
    > these text files into Access (using a macro, vbs, whatever) when the
    > file name of each newly-created text file will change? For example, the
    > first archived log file would be named "Syslog07-23-06.txt" but the
    > next would be "Syslog07-30-06.txt", and so forth.
    >
    > Hopefully some of you will consider this a piece of cake, because it's
    > way beyond me.
    >
    > Thanks,
    >
    > FL
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Check Out DoCmd.TransferText

    Pieter

    "FuzzyLogic" <corey.robinson@knoxcommhosp.org> wrote in message
    news:1153934951.054751.179540@m79g2000cwm.googlegroups.com...
    > I've been doing Google searches for hours on this subject without
    > finding exactly what I'm looking for, so before I settle for something
    > different than what I really want to do, I figured I'd ask the
    > experts...
    >
    > I'm taking it upon myself to set up a syslog server in a primarily
    > Windows Server 2003 environment, using free software and scripts I've
    > collected from the web (have no budget, this is just something we need
    > and I'm tired of trying to convince people of that.) What I have so far
    > is a syslog server that collects event log information from multiple
    > Windows Server 2003 machines and dumps them into a
    > continuously-updating text file. On a weekly basis, this text file is
    > dumped to another directory on the syslog server as a text file with a
    > time and date stamp.
    >
    > What I'd like to do is create an MS Access database wherein these text
    > logs are automatically imported to give our IS department access (no
    > pun intended) to the event logs using a versatile front end (MS
    > Access.) Trouble is I have no MS Access experience, so I'm stumbling
    > along. Cruising Google Groups, I've found out how to do an initial
    > import of one of these text files using the Import Wizard, and how to
    > set it up to columnize the data properly. Then I read how to create a
    > macro to perform this function. Fantastic.
    >
    > One hitch...The macro is dependant upon a text filename that does not
    > change. I've found that I can make the macro prompt a user for a
    > filename to import, but I'd really like to make this hands-free if at
    > all possible. Is there any possible way I can automatically import
    > these text files into Access (using a macro, vbs, whatever) when the
    > file name of each newly-created text file will change? For example, the
    > first archived log file would be named "Syslog07-23-06.txt" but the
    > next would be "Syslog07-30-06.txt", and so forth.
    >
    > Hopefully some of you will consider this a piece of cake, because it's
    > way beyond me.
    >
    > Thanks,
    >
    > FL
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page