Sniffer Pro Distributed, I want to create an MS Access database to the CSV files to create reports and charts

Posted on 2004-11-15
Last Modified: 2006-11-17
Sniffer Pro Distributed, I want to create an MS Access database to the CSV files to create reports and charts.  I have never looked at this before but has someone already done this?  I don't want to re-invent the wheel if I don't have to.
Question by:RDAdams
    LVL 9

    Accepted Solution


         Sorry, but absent a "crack", the answer is Sniffer Pro saves history samples as files with a .HST extension. This extension is a proprietary format that cannot be directly imported into a third-party application.  To export history samples, a history graph must be the active window in Sniffer Pro.  The three export formats are Comma Separated Value (CSV), text with tab delimiters, and text with space delimiters.

    If you always saved in the same folder, you could have an import macro that automated importing *.hst from that folder, and appending it to a table.

    LVL 17

    Author Comment

    It saves daily tallies as CSV format.  I can look directly at the CSV formats but I am looking to combine data for over a year.  The HST files are normally only kept for 14 days or less depending on the system.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now