newbie question

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 thanksSearch 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.|||Hi strawberry ,
U can try through import external data wizard from excel... Try it out.
Reg
Arijit|||For an alternative try this also

http://sqljunkies.com/WebLog/madhiv...7/27/16233.aspx

Madhivanansql