G Guest Nov 25, 2004 #1 there are many existing tables, and i want to get the create SQL for them, how to do that ?
J John Vinson Nov 25, 2004 #2 there are many existing tables, and i want to get the create SQL for them, how to do that ? Click to expand... There's no automated way to do so in Access. A couple of people have written VBA code to use the DAO Fields collection to construct DDL SQL statements, but I haven't worked with them. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
there are many existing tables, and i want to get the create SQL for them, how to do that ? Click to expand... There's no automated way to do so in Access. A couple of people have written VBA code to use the DAO Fields collection to construct DDL SQL statements, but I haven't worked with them. John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps
