Converting an SQL server table structure to an MS-Access table

[Andrew Chalk]

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.

 

[Matt Smith]

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

 

[Andrew Chalk]

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.