[dba-SQLServer] Export from SQL to Access

You might also try Visio Professional.


At 12:00 PM 10/8/2009, you wrote:
>Date: Thu, 8 Oct 2009 07:08:10 -0500
>From: "Dan Waters" <dwaters at usinternet.com>
>Subject: [dba-SQLServer] Export from SQL to Access - Include Table
>         Relationships?
>To: "'Discussion concerning MS SQL Server'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <FD5D6F4624784A549D925CA4004DB36D at danwaters>
>Content-Type: text/plain;       charset="us-ascii"
>
>Hello Everyone!
>
>I found out how to export data tables from SQL to Access using SSIS.
>However, the table relationships did not come across.
>
>Is there a method in SQL or Access to quickly copy tables from SQL to Access
>and include the table relationships?
>
>Thanks!
>Dan