Exporting From SQL Server To MSACCESS

Hi,

I Need to make a script or task that programmatically export data from SQL Server to Access File , and how to call the script from the .NET?

Create SSIS package using Import/Export Wizard, you can then run this package from any .NET application either by running DTEXEC or using SSIS object model - see SQL Books Online for sample syntax of both.

export resultsets in ms access

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
"Vikram" wrote:

> 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.
>
>