Thursday, November 4, 2010

Import Export data between Excel and SQL Table

In SQL 2005 it is preety simple to pull the data from Excel sheet to SQL table but in SQL 2008 we have to set one setting first to do the same work. Select Project-- press right mouse button and go in properties-- Project properties window will open. Click on Debbuging option and set Debug options (Run64BitRuntime) to False. Rest all steps are same as we had in SQL 2005. Make sure while pulling data from Excel to Table need to use Data Conversion Transformation.