Newbie?: Can This Be Done?- If so please direct

28 Apr 2006 8:33 PM

Randy

Hello NG

I have been working with Access for a Long Time - Am just now starting
to get my feet wet with SQL Server 2000 - We have a production database that
we have moved the tables to SQLServer and I have been creating stored
procedures to replicate some of the processes done on the access side - the
server does process extremely faster than access - Here is my problem I am
currently pulling info from SQL SERVER to Access once a week for weekly
stats I want to create a stored procedure to process the weekly stats and
push them to an access table upon request - we have multiple warehouses and
i would like to have the process coded once in sql and dump to the access
table based off a warehouse variable passed to the stored procedure - Can
SQLServer from a stored procedure export a recordset into a varible defined
Access Table?

TIAFAH

Randy

30 Apr 2006 3:29 AM

Alan Samet

It sounds like DTS is what you're looking for. I don't know that I
would recommend this approach to an experienced SQL Server developer
because of its limitations, but in what you're asking for, it seems
ideal. Open Enterprise Manager, right-click your database, select
"Export Data" (it might be under a submenu), follow the wizard. I'm
pretty sure you can specify a stored procedure for the source. If I
remember correctly, you may also schedule the package to run at
intervals.

-Alan

Randy wrote:
Show quote

> Hello NG
>
> I have been working with Access for a Long Time - Am just now starting
> to get my feet wet with SQL Server 2000 - We have a production database that
> we have moved the tables to SQLServer and I have been creating stored
> procedures to replicate some of the processes done on the access side - the
> server does process extremely faster than access - Here is my problem I am
> currently pulling info from SQL SERVER to Access once a week for weekly
> stats I want to create a stored procedure to process the weekly stats and
> push them to an access table upon request - we have multiple warehouses and
> i would like to have the process coded once in sql and dump to the access
> table based off a warehouse variable passed to the stored procedure - Can
> SQLServer from a stored procedure export a recordset into a varible defined
> Access Table?
>
> TIAFAH
>
> Randy