Import data from Excel

[cpitc]

I am using SqL Server Management Studio Express and want to import some data into a table from an excel spreadsheet. I dont have the import facility due to me using Studio express. Does anyone know how I can import this small spreadsheet into the table please.

 

[markros]

Check this video

http://www.youtube.com/watch?v=9Wmdhnx1niU

PluralSight Learning Library

 

[cpitc]

Thanks for the link. The problem is SqL Server Management Studio Express does not have the Import and Export routines. Therefore I am trying to find another way, perhaps through scirpt that can do this routine. Thanks

 

[markros]

It does. You have Import/Export task in you right click on the database in SSMS. It doesn't have SSIS, but it does have the Import/Export wizard.

PluralSight Learning Library

 

[cpitc]

Im afraid I cannot see it on mine (2005 version.

If I right mouse click on my database name under Tasks I only have the options for
Detach
Shrink
Backup
Restore
Genrate Scripts

The Iport /Export does not show anywhere elas on the menus.

Any ideas? Thanks

 

[markros]

I'm using SQL Server 2008 Express. When I right click on the Database, I see at the bottom Import Data / Export Data menus.

PluralSight Learning Library

 

[PRPhx]

Take a look here:

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/546f4407-0aa4-4b04-96f3-e6f0ba39a9d1/

 

[markros]

Good point, PRPhx - I actually saw that thread before and completely forgot.

PluralSight Learning Library

 

[cpitc]

Ok I managed to get the download and now I ahve the import and export tool. I managed to get one excel spreadsheet into SQL, but on my second one, when I go into edit the mappings it is only giving me the option to Create Destination Table. The table already exisits in the databse so I just want it to Append the records on from the excel sheet, but the options ar greyed out. Any ideas what I can do here or what is causing this problem.

Thanks