|
|
| strawberry 2005-07-28, 8:24 pm |
| i need to import data to excel from an sql db. the sql db is on a server,
excel will be on a remote computer. I'm quite happy to use access as an
intermediary if needed. i would also like to be able to write from excel to
sql is poss. although it this if tricky then i might well concentrate on
importing.
is any of this possible? if so is it hard? and can anyone point me to any
decent resources.
many thanks
| |
|
| Search for DTS packages in the SQL Books Online.
That should help you with what you want to do.
>i need to import data to excel from an sql db. the sql db is on a server,
> excel will be on a remote computer. I'm quite happy to use access as an
> intermediary if needed. i would also like to be able to write from excel
> to
> sql is poss. although it this if tricky then i might well concentrate on
> importing.
>
> is any of this possible? if so is it hard? and can anyone point me to any
> decent resources.
| |
| arijitchatterjee123@yahoo.co.in 2005-07-29, 7:23 am |
| Hi strawberry ,
U can try through import external data wizard from excel... Try it out.
Reg
Arijit
| |
|
|
|
|