Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Location
    Brazil
    Posts
    19

    Unanswered: Export table to MAccess from SQL Store Procedure

    Hi people.

    I need some help to export a table to Microsoft Access using a Store Procedure.

    My Store Procedure will pupolate a temporary table with some information. After that I want that the store procedure export this table to Access.

    Is there any script or command that can do it? And how can i use it into a Store Procedure?

    Please, if possible give a example.

    thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    DTS is almost certainly what you want.

    -PatP

  3. #3
    Join Date
    May 2004
    Location
    Brazil
    Posts
    19
    How can i do it???? can you give a example????

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Follow the link I provided. There are several hundered examples provided there!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •