Export query design

[somm]

I need some help on exporting query designs in excel format or text format so that i can create new DB. I i have large database where we are using more than 30 queries. i know we can copy the SQL statements bit its a nasty thing.

Is there anyway to export query design like macro exporting.

Thanks.

[NoellaG]

Hi,

all depends on the format of the other database. If it's another access database in the same version or a higher version, you can open this database and then import the queries, or any other object you want by the External Data/Import functions.
If it's another database system (mySQL, Oracle, SQl server, ...) it probably will have another SQL syntax, so you'll have to rewrite the queries in the proper syntax.

gr
NG

[somm]

They are in the same format but the problem is these two files are located in different servers and locations. They don't have connections.