MS Access Query Import?

robb.claxton_1238097 · May 4, 2011, 9:14am

Is it possible to import an access query into toad?

Debbie_Peabody · May 4, 2011, 11:03am

You don’t need to import it. Just connect to Access using TDA 2.7 trial or commerical. There is a Query tab in the object explorer.

Debbie

robb.claxton_1238097 · May 4, 2011, 11:56am

Debbie how is the query managed. I have found that access is slow when handling queries where it tries to index data locally. Toad seems more reponsive.

Debbie_Peabody · May 4, 2011, 2:25pm

I’m not sure actually. We use ODBC to connect to access and have optimized our code.

Debbie