SQL Srvr 2005 Express & import

You need SSIS to do this, which comes with versions other than Express. Or
you can write a VBScript which uses ADO ;-)

"DJPogoff" wrote in message
news:3EA497C2-7DF4-441B-9382-ECE578F86E50@microsoft.com...
> Can one import data from outside sources (e.g., Excel) using SQL Server
> 2005
> Express Tools or the Management Studio Express? If not, which versions of
> SQL Server 2005 allow for data import and export?
>
> Thanks for any help or advice.
>
> Regards,
>
> David

THanks for your help. Does SSIS come with _every_ version other than
Express? Also, what does SSIS stand for?
--
Thanks and regards,

David
----------
"bass_player [SBS-MVP]" wrote:

> You need SSIS to do this, which comes with versions other than Express. Or
> you can write a VBScript which uses ADO ;-)
>
> "DJPogoff" wrote in message
> news:3EA497C2-7DF4-441B-9382-ECE578F86E50@microsoft.com...
> > Can one import data from outside sources (e.g., Excel) using SQL Server
> > 2005
> > Express Tools or the Management Studio Express? If not, which versions of
> > SQL Server 2005 allow for data import and export?
> >
> > Thanks for any help or advice.
> >
> > Regards,
> >
> > David
>
>
>

you can import data from Excel with SQLExpress. Checkout Opendatasource in
BOL and have a look at http://support.microsoft.com/kb/321686

Ulrich


"DJPogoff" wrote in message
news:3EA497C2-7DF4-441B-9382-ECE578F86E50@microsoft.com...
> Can one import data from outside sources (e.g., Excel) using SQL Server
> 2005
> Express Tools or the Management Studio Express? If not, which versions of
> SQL Server 2005 allow for data import and export?
>
> Thanks for any help or advice.
>
> Regards,
>
> David

> Does SSIS come with _every_ version other than
> Express?

Yes, at various levels. See http://www.microsoft.com/sql/prodinf...-features.mspx.

SQL Server Integration Services.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"DJPogoff" wrote in message
news:C627287C-EB9B-4027-A31D-7E783DB4EA74@microsoft.com...
> THanks for your help. Does SSIS come with _every_ version other than
> Express? Also, what does SSIS stand for?
> --
> Thanks and regards,
>
> David
> ----------
> "bass_player [SBS-MVP]" wrote:
>
>> You need SSIS to do this, which comes with versions other than Express. Or
>> you can write a VBScript which uses ADO ;-)
>>
>> "DJPogoff" wrote in message
>> news:3EA497C2-7DF4-441B-9382-ECE578F86E50@microsoft.com...
>> > Can one import data from outside sources (e.g., Excel) using SQL Server
>> > 2005
>> > Express Tools or the Management Studio Express? If not, which versions of
>> > SQL Server 2005 allow for data import and export?
>> >
>> > Thanks for any help or advice.
>> >
>> > Regards,
>> >
>> > David
>>
>>
>>

Not true, Download the SQL server 2005 express toolkit - this will give you
the DTS interface and plae it in the folder C:\Program Files\Microsoft SQL
Server\90\DTS\Binn

From there you can then add this through the external tools menu in express
2005 and be able to access it from the ide.

url:http://ureader.com/msg/11621388.aspx