I Intense_SS New member Local time Yesterday, 16:17 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, 00:17 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 Yesterday, 19:17 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.