Move Access Table Structure to SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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