Move Access Table Structure to SQL Server

[MEG]

I have prototyped some tables in Access to show "proof of
concept".

Is there a way to "upload" these table structures to SQL
Server 2000?

Just wondering if there is a shortcut instead of manually
building CREATE TABLE statements.

THANKS,

MEG

 

[Duane Hookom]

Create a dsn to the sql database and then export the tables to your SQL
database. You can also use DTS to move your tables to SQL.