I have a sp which return mutiple result set.
Is there any way by which i can export the multiple resultset data in ms
access using some tool, DTS etc.

ADO in VBA supports the NextRecordset method for doing this and it is
possible in MSAccess.  Check the help for NextRecordset.

Hope that helps.

Let me know how you get on.

Damien

Show quoteHide quote

can't delete a row from primary table - is there an SP for this?
Ranking Rows
T-SQL
Convert(datetime, '07/11/48') Returns Year 2048!!
UPDLOCK blocking readers