Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Arrow Unanswered: Exporting Data+Structure

    Hello E'body,

    I have to export a SQL Server Table (Structure+Data) to an access mdb file at run time. How can i do it? please help.

    Lax.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can use DTS wizard in SQL Server to accomplish the task.
    For information review topics available in SQL books online.

    ONce you've designed the package, can schedule it to run as a job at run time.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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