[dba-SQLServer] Export from SQL to Access

Hi Dan:

Have you tried your ODBC data source manager yet?

Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Thursday, October 08, 2009 1:53 PM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] Export from SQL to Access

Hi Rob,

I tried to get this to connect to sqlexpress on my PC, but after an hour
it's still not working.

I'll try again later.

Thanks!

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert
Stewart
Sent: Thursday, October 08, 2009 1:45 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Export from SQL to Access

http://www.sqlpower.ca/page/download?fileName=http://power-architect.googlec
ode.com/files/Architect-Setup-Windows-jdbc-0.9.13.exe

may work


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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com