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
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
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.
Category Web application programming
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
Recover
Did you mean to delete that important email from your boss? No? Whoops! Never mind, here’s how you can get it back.
Category Microsoft Outlook
Outlook 2003: Flagging Emails For Better Productivity
Category Microsoft Outlook
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
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