SQL Srvr 2005 Express & import

13 Nov 2007 10:53 PM

DJPogoff

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

14 Nov 2007 5:22 AM

bass_player [SBS-MVP]

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

Show quote

"DJPogoff" <djpogoff_at_complexNOSPAMnet_dot_com> 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

14 Nov 2007 6:20 PM

DJPogoff

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

--
Thanks and regards,

David
----------

Show quote

"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" <djpogoff_at_complexNOSPAMnet_dot_com> 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
>
>
>

15 Nov 2007 11:05 AM

Tibor Karaszi

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

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

SQL Server Integration Services.

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

Show quote

"DJPogoff" <djpogoff_at_complexNOSPAMnet_dot_com> 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" <djpogoff_at_complexNOSPAMnet_dot_com> 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
>>
>>
>>

14 Nov 2007 6:46 PM

Ulrich

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

Ulrich

Show quote

"DJPogoff" <djpogoff_at_complexNOSPAMnet_dot_com> 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