katy8439's tutorials

Import CSV file directly into MySQL

Contributed by katy8439 on May 8, 2007 under 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.

Comments Continue reading... 
 

SQL 2000 – Find version and service pack info

Contributed by katy8439 on under Database

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.

Comments Continue reading... 
 

SQL2000 – Find Database Language

Contributed by katy8439 on under Database

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

Comments Continue reading... 
 

Classic ASP: Generate Excel spreadsheets on the fly

Contributed by katy8439 on October 11, 2006 under Web application programming

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

Comments Continue reading... 
 

Remove All Hyperlinks in Word or Excel

Contributed by katy8439 on April 3, 2006 under Microsoft Office

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

Comments Continue reading... 
 

Recover

Contributed by katy8439 on December 6, 2005 under Microsoft Outlook

Did you mean to delete that important email from your boss? No? Whoops! Never mind, here’s how you can get it back.

Comments Continue reading... 
 

Outlook 2003: Flagging Emails For Better Productivity

Contributed by katy8439 on November 16, 2005 under Microsoft Outlook

Organise you emails into manageable folders automatically using Filters and Flags in Outlook 2003

Comments Continue reading... 
 

Make your blog search engine friendly

Contributed by katy8439 on November 14, 2005 under Internet

How to make sure your blog is set up for search engine spiders – it’ll improve the user experience too!

Comments Continue reading...