"Casper" <c@px.x> wrote in message
news:OCgp6JmaHHA.3272@TK2MSFTNGP03.phx.gbl...
> Hello,
>
> i'm looking after the possibility of importing / exporting data from / to
> Excel and Access.
>
>
> Thanks for help
> Casper
>

> There are several ways to accomplish this. The simplest is using the
> OPENROWSET or OPENDATASOURCE TSQL syntax. Check BOL. You could also
> import export XML which can be opened using Excel, or use CLR objects in
> SQL2005 or perhaps sp_OA... functionality in earlier versions to directly
> access the specific files.
>
>
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Casper" <c@px.x> wrote in message
> news:OCgp6JmaHHA.3272@TK2MSFTNGP03.phx.gbl...
>> Hello,
>>
>> i'm looking after the possibility of importing / exporting data from / to
>> Excel and Access.
>>
>>
>> Thanks for help
>> Casper
>>
>
>