I want to take an existing MS-SQL Server table in an SQL Server database and
create an MS-Access table with the same structure. Is there a standard
utility to do this?

Many thanks.

Usually people are wanting to go the other way, from Access to SQLS.
No, there's no utility that I know of, but there's a couple of ways
you can go about it. You can create an Access database and link to the
SQLS one, then create a Make Table query. You'll need to manually put
in keys, indexes, and constraints as validation rules. A second way
would be to create a script using SEM's recording capabilities. You
could then revise it so that it is compatible with Access/Jet DDL. A
third way would be to use DAO, but you'd need to write the code.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Mon, 14 Jul 2003 13:23:51 -0500, "Andrew Chalk"
<achalk@XXXmagnacartasoftware.com> wrote:

>I want to take an existing MS-SQL Server table in an SQL Server database and
>create an MS-Access table with the same structure. Is there a standard
>utility to do this?
>
>Many thanks.
>

"Andrew Chalk" <achalk@XXXmagnacartasoftware.com> wrote in message
news:OUTSVUjSDHA.2316@tk2msftngp13.phx.gbl...
> I want to take an existing MS-SQL Server table in an SQL Server database
and
> create an MS-Access table with the same structure. Is there a standard
> utility to do this?
>
> Many thanks.
>
>

It isn't perfect but you could try using Microsoft Data Transformation
Services Wizard ("<SQL 7 Install Dir>\Binn\dtswiz.exe"). It comes with any
version of MSDE.

Matt

Thanks. However, I need a programatic solution.

At the moment I copy an empty MDB to the target directory and then open the
SQL Server and Access dbs as ODBC data sources and SELECT and INSERT each
record in turn.

Regards.

"Matt Smith" <_matt@breathemail.net> wrote in message
news:bf11nc$col$1@sparta.btinternet.com...
> "Andrew Chalk" <achalk@XXXmagnacartasoftware.com> wrote in message
> news:OUTSVUjSDHA.2316@tk2msftngp13.phx.gbl...
> > I want to take an existing MS-SQL Server table in an SQL Server database
> and
> > create an MS-Access table with the same structure. Is there a standard
> > utility to do this?
> >
> > Many thanks.
> >
> >
>
> It isn't perfect but you could try using Microsoft Data Transformation
> Services Wizard ("<SQL 7 Install Dir>\Binn\dtswiz.exe"). It comes with any
> version of MSDE.
>
> Matt
>
>