How to generate SQL script for Access databas?

[news.comcast.net]

Hi,
I am trying to generate sql scripts from Access database that can be used to
create databases in different database systems. I have tried a few third
party tools such as Interbase Data Pumper and SQL To Interbase Wizard;
however, they don't do the job well.

Please help.

GD

 

[Anand.V.V.N]

Hi,

I am nost sure if this would be the exact solution but its a long shot might
work. Have a form in access, have a button that would call create a odbc for
the database, connect to the database say orcale, then create a database
usign the access sql.

I am not sure though if this is possible, may be possible in VB though.

Hope you find this useful.

Anand