sql server (alternate): Search for DTS packages in the SQL Books Online.
That should help you with what you want to do.


[quoted text, click to view]

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

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/madhivanan/archive/2005/07/27/16233.aspx

Madhivanan