Import Data in SQL Server 2005?

I'm using SQL Server 2005 Management Studio Express, and trying to import data from an Excel spreadsheet into a new table. I'm used to doing this through Enterprise Manager in SQL Server 2000, but I'm not sure how to do it in the new interface. Is there a way to do a simple data import without also installing Business Intelligence Development Studio?

hi,

nope..

all this "stuff" has now be included in SSIS (integration service), not available in SSMSE as SQLExpress does not include the required runtime at all..

but you can perhaps interact with "linked servers" scenario and perform INSERT ... SELECT ...

something like http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=670748&SiteID=1

regards

|||Thank you!