I Intense_SS New member Local time Today, 06:54 Joined Sep 5, 2012 Messages 3 Sep 5, 2012 #1 Does anyone know if there is a way to convert my MS Access Database tables into SQL commands?
Y YNWA Registered User. Local time Today, 14:54 Joined Jun 2, 2009 Messages 905 Sep 5, 2012 #2 Connect your Access Project within SQL Server
P Pat Hartman Super Moderator Staff member Local time Today, 09:54 Joined Feb 19, 2002 Messages 47,663 Sep 6, 2012 #3 Intense_SS said: Does anyone know if there is a way to convert my MS Access Database tables into SQL commands? Click to expand... I don't understand the question? Are you asking if you can make DDL from Access to create a table in SQL Server? The easiest way is to use the upsizing wizard and then use SQL Server itself to create the CREATE TABLE DDL.
Intense_SS said: Does anyone know if there is a way to convert my MS Access Database tables into SQL commands? Click to expand... I don't understand the question? Are you asking if you can make DDL from Access to create a table in SQL Server? The easiest way is to use the upsizing wizard and then use SQL Server itself to create the CREATE TABLE DDL.
