Saturday, February 25, 2012

Schedule export from sql database to access

Hi
Can someone explain/help how can I create a schedule at SQL Server 2000 that
exports at X time of the day a SQL database into a access database without
exporting the views that the SQL database has.
Thanks
[]
RickyTake a look at the Import/Export wizard and sql agent in BooksOnLine.
Andrew J. Kelly SQL MVP
"Ricky" <newsgroupsmail@.gmail.com> wrote in message
news:OTItwJhVHHA.4872@.TK2MSFTNGP03.phx.gbl...
> Hi
> Can someone explain/help how can I create a schedule at SQL Server 2000
> that
> exports at X time of the day a SQL database into a access database without
> exporting the views that the SQL database has.
>
> Thanks
> []
> Ricky
>
>

No comments:

Post a Comment