Posts by katy8439
    Posted May 8, 2007 by

    Import CSV file directly into MySQL

    Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax.

    Category MySQL

    Posted May 8, 2007 by

    SQL 2000 – Find version and service pack info

    Run the following code in SQL Server 2000 Query Analyzer to return the Version and Service pack – useful if you’re having problems on a server and don’t know if you’re running the latest patches or not.

    Category Database

    Posted May 8, 2007 by

    SQL Server 2000 – Find Database Language

    How to find the system language of a server running SQL Server 2000 using a SQL statement.

    Category Database

    Posted October 11, 2006 by

    Classic ASP: Generate Excel Spreadsheets on the Fly

    The following script allows you to generate an Excel spreadsheet from data stored in an access database.

    Posted April 3, 2006 by

    Remove All Hyperlinks in Word or Excel

    These two nifty macros enable you to delete the embedded hyperlinks that are generated when typing URLS or copying information from the web.

    Category Microsoft Office

    Posted December 6, 2005 by

    Outlook: Recover a Deleted Email Message

    Did you accidently delete an important email message from your inbox? Fortunately, with Outlook, getting it back is possible. Keep reading to find out how this is done.

    Posted November 16, 2005 by

    Outlook 2003: Flagging Email Messages for Better Productivity

    In Outlook 2003, you can automatically organize your email messages into manageable folders using Filters and Flags. This tech-recipe explains how this is done.

    Posted November 14, 2005 by

    Make Your Blog Search Engine Friendly

    Ensuring that search engine spiders find your site attractive and can locate it easily are keys to maintaining a successful blog. This tutorial contains useful tips and instructions for achieving this goal.

    Category Internet

    Posted November 10, 2005 by

    Market Your Blog and Keep Your Readers

    Many blog publishers seem to subscribe to the view, “If you build it, they will come.” Unfortunately, this is not the case in 99% of blogs. Some people write blogs to air their own opinions, some write about a particular passion, and some write as a job or about their business. So how do you […]

    Category Internet