[AccessD] Access Scripting Tool

[Paul Wolstenholme]

Arthur,

I've coded a spreadsheet to give me the table create alter and delete
statements from a list of table names, fields, types and descriptions.
Another sheet handles indexes and another the relationships.
My spreadsheet is a great reference tool if I keep the parts I need up to
date (i.e, there is a cost for the benefit).  It is also my starting point
for designing the database structure (great for making sure linked fields
are defined consistently).
But ... my formulae are only valid for SQL Server tables.

Paul Wolstenholme


On Thu, 16 Mar 2023 at 05:05, Arthur Fuller <fuller.artful at gmail.com> wrote:

> Is there any tool that will generate the DDL and SQL code to create all the
> tables and then populate them? The DDL code would be all the CREATE
> statements and the SQL code would be all the INSERT statements.
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>