[AccessD] Generate DDL statements from an Access db?

Arthur,

I have a module called DataDictionary. It has procs DocumentTables,
FieldType and fjListPrimaryKeys. It creates a table called Data_Dictionary.
I use it for basic documentation of Table fields/columns.

I have attached the code as  ForArthur.bas

I also found a link to an Access DDL generator -- says it can be tried
before buying.
http://www.download3k.com/Software-Development/Editors-Tools/Download-DBWScr
ipt.html
I haven't tried it nor used it.

I don't know if either of these is helpful, but that's what I have that may
assist.

jack

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, February 03, 2008 2:20 PM
To: Access Developers discussion and problem solving; Discussion concerning
MS SQL Server
Subject: [AccessD] Generate DDL statements from an Access db?

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.

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com