create SQL Server table from Access table

J

JonathanK

Does anyone know where there is some Access VBA code that
will scan a table in MS Access, (looking at all fields)
and output a CREATE TABLE statement that could be used to
create a "clone" of the table in SQL Server.

This has to have been done before!

Many thanks,

Jonathan K.
 
D

david epsom dot com dot au

Use the upgrade wizard to upgrade to SQL Server, then
use SQL Server to create a SQL Server Script for the
table.
(david)
 
Top