export and import data

Question

Post reply

export and import data

raaz66

Mr or Mrs. 500

Points: 598
More actions
August 6, 2009 at 10:51 pm

#213251

i want to export data from sql server 2005 to microsoft excel 2007/2003 and similarly import data from ms excel to sql server2005

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

JamieX Hall of Fame Points: 3763 More actions · Answer 1

you can use the import/export wizard in SSMS. Right click database, goto Tasks, then Import (or export) Data

MartinSchmidt Mr or Mrs. 500 Points: 525 More actions · Answer 2

With SSIS is it very easy to read/write data to/from Excel.

So i would have a llok at that

/mSc

http://www.performanceduo.com

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Hi

If you need to this frequently you can implement this using SSIS. If you do this on rare occasions then just use the import/export wizard.

"Keep Trying"

leksshmanan.alagappan Valued Member Points: 66 More actions · Answer 4

If you have installed SQL server on the default directory look for the dts import/export wizard at C:\Program Files\Microsoft SQL Server\90\DTS\Binn folder.

As said by previous answerers , use the dts import/export wizard for one time data movement and SSIS packages for a regularisied data import and export.

Hope this helps!

Leks