Showing posts with label exports. Show all posts
Showing posts with label exports. Show all posts

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