How to generate SQL script for Access databas?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.comcast.net - 15 Jul 2005 21:37 GMT

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

Reply to this Message

Anand.V.V.N - 18 Jul 2005 06:18 GMT

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

Signature

"Who will guard the guards?"

> Hi,
> I am trying to generate sql scripts from Access database that can be used to
[quoted text clipped - 5 lines]
>
> GD

Reply to this Message