How to generate create table statments using vba

[tony007]

Hi guys . I saw and example in code repository

Export All Database Objects Into Text Files 
by ghudson  

[url]http://www.access-programmers.co.uk/forums/showthread.php?t=66320[/url]

and it was writing all the access object to text file. I want to do similer but instead of adding just feild parts with its population . I want the create table statment for each table in access database. I want the create table satemetns be corect so if i paste it in sql view of access db it runs and creates that table for me. I want the table name , feild name,type,size and primary key and forgin key as well.I be happy if some expert show me how to do this.Thanks

 

[modest]

I don't think you know what you're talking about.

You cant just generate SQL from a table.
What hudson did was take objects already located in your database file and export them to text files
The only way to get what you want is to already have Create-Table queries and then export those to text. But it was already listed how to export a query to a text file.

 

[kdnichols]

Hello,

I found this thread while doing a search. It does not appear when you click on the link.

I would like to view this. Can a Moderator or Administrator fix this?

Thanks,

Kurt