Obtaining an Access database structure

[Simon Elliott]

Hi

I want to create some tables in an Access database via SQL CREATE TABLE
etc. The tables must have the same structure as those in an existing
Access database.

In order to put together my SQL statements, it would be useful to be
able to export the existing database structure to a text file. This
would minimise the risk of error due to mistyped field names etc. Is
there any way of doing this? I'm currently using Access 97.

Thanks in advance for any suggestions.

 

[Arvin Meyer]

Hi

I want to create some tables in an Access database via SQL CREATE TABLE
etc. The tables must have the same structure as those in an existing
Access database.

In order to put together my SQL statements, it would be useful to be
able to export the existing database structure to a text file. This
would minimise the risk of error due to mistyped field names etc. Is
there any way of doing this? I'm currently using Access 97.

I'm sure you want the equivalent of the scripts which SQL-Server can create.
And that may not be possible. I have a database on my website which will
enumerate all fields in all tables. If you then output the results into a
query, it may give you close to what you need.

http://www.datastrat.com/Download/FieldDescription2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Simon Elliott]

I'm sure you want the equivalent of the scripts which SQL-Server can create.
And that may not be possible. I have a database on my website which will
enumerate all fields in all tables. If you then output the results into a
query, it may give you close to what you need.

http://www.datastrat.com/Download/FieldDescription2K.zip

Thanks. Unfortunately as I only have Access 97 I can't open that
database.