How to generate SQL script for Access databas?

  • Thread starter Thread starter news.comcast.net
  • Start date Start date
N

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