[dba-SQLServer] Generate DDL statements from an Access db?

Susan Harkins ssharkins at gmail.com
Sun Feb 3 13:23:46 CST 2008



> Does anyone know of a program that will generate CREATE TABLE statements
> from an Access database? My import and export wizard seems to be broken 
> and
> the disks are off-site. I would just do it by hand but several of the 
> tables
> have lots of columns.

=========Would the SQL View window be of any help -- I mean, you could use 
the design window to drag and drop, then cut and paste from the SQL View 
window and insert CREATE TABLE manually -- might beat a blank.

Susan H. 




More information about the dba-SQLServer mailing list