Obtaining an Access database structure

  • Thread starter Thread starter Simon Elliott
  • Start date Start date
S

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.
 
Simon Elliott said:
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.
Click to expand...

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
 
Back
Top