I have a SQL server data base

I need the code of stored procedure that operate Export of the Data Base to Access file

How to write it?

Hi there,

You can't do that with a stored procedure directly. However, you can use DTS (Data Transformation Services) for that. This is part of SQL Server and is designed for these kind of tasks.

Look in the Books Online for DTS or search Google and you'll find a lot of information about it.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The Bazaar by The Tea Party (Track 2 from the album: The Edges Of Twilight) What's This?