copying queries across databases

[cronid]

I have nearly 100 queries in an Access database which links to a SQL Server database. The queries are working just fine.

I have created a new Access database, linking to a different SQL Server database which has the same table layouts as the first. Is there a way to automatically copy the queries from the first Access database to the second?

 

[Jerry Stoner]

File - Get external data - import

 

[cronid]

Thanks, jerry.

That works.