Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2004

Tip: Looking for answers? Try searching our database.

Move Access Table Structure to SQL Server

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MEG - 18 Dec 2004 03:13 GMT
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 - 18 Dec 2004 04:37 GMT
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.

Signature

Duane Hookom
MS Access MVP

>I have prototyped some tables in Access to show "proof of
> concept".
[quoted text clipped - 8 lines]
>
> MEG
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.