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

A

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.
 
M

Matt Smith

Andrew Chalk said:
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.
Click to expand...

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
 
A

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.
 
Top