Merry Christmas

Wish you all Peaceful & Joyful Christmas !!!

How to Insert Data in Text file to SQL Database

Problem:

Insert large amount of data in text file to a SQL database table with minimum time.

 

Solution:

Using ‘Bulk Insert’ is the solution.

I had to import large amount of data in text file to SQL database. If I programmatically insert this data, it would take more time and memory. Therefore, I use SQL bulk insert to import this data. If the fields in the data files are separated using a special character (comma – ‘,’) they can be directly insert in to columns in the database with one query. In addition, it can be fields are not separated, but have known lengths. Then you have to substring them according to lengths.

How to Import data in Excel sheet to SQL Express Database using AD-HOC Query

This something I got to do, Import data in Excel 2007 sheet to table in MS SQL database in SQL Express 2005. So I'm blogging it anyone who need can quickly get it done.
Here are the details you need to know:
Excel File: D:\MyTable.xls
Excel Sheet: Sheet1
SQL database: NewTestDB
Database Table: TestTable (This doesn't exist yet)

How to Install Age of Empires Online / NFS World to Drive other than System Partition

I was installing Age of empires Online on my PC. My system partition (C:\) was almost full. So i installed it on another drive. But by default it download the game files (patch files) to User's home folder ("C:\Users\UserName\AppData\Local\Microsoft\Age of Empires Online") to prevent the any privilege issues. But its about 4 GB of Data. And they don't offer any option to download them to another drive. So I have to find a solution to this. This is how I did it, and I am sharing it you all as it would become useful to every one.

Urban Nature

Temple Of Tooth (ශ්‍රි දළදා මාලිගාව)