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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Best way to deploy Access read-only database that is linked to SQL tables 6
query links to SQL server and mdb table 1
Some mail merge fields not pulling into document 2
Move Access Table to SQL Server 1
URGENT: Exporting table to an SQL script 13
How many user licenses required for SQL Server BE 5
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0

Top