Create table script

[Olivier Matrot]

I would like to generate SQL create table statements from existing access
database tables. Is it possible ?
TIA.

 

[Graham Mandeno]

Hi Oliver

It's certainly possible. You can easily use DAO to enumerate all the Fields
and Indexes of a TableDef and ascertain their properties. It's then just a
matter of converting that information into a valid Create Table string.

I'm sure someone, somewhere must have done this before, so you might find
you can save time with a bit of judicious Google-ing before you sit down to
write the code yourself.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

 

[Özden Irmak]

Hello,

In a few days, Klik! Software is going to release a new tool called Klik!
CompareLib which can compare and synchronize the structures of MSAccess
databases. This tool may be helpfull for you...

http://www.kliksoft.com/

Regards,

Özden Irmak
President
Klik! Software

Hi Oliver

It's certainly possible. You can easily use DAO to enumerate all the Fields
and Indexes of a TableDef and ascertain their properties. It's then just a
matter of converting that information into a valid Create Table string.

I'm sure someone, somewhere must have done this before, so you might find
you can save time with a bit of judicious Google-ing before you sit down to
write the code yourself.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

I would like to generate SQL create table statements from existing access
database tables. Is it possible ?
TIA.