MS QUERY

  • Thread starter Thread starter Howie
  • Start date Start date
H

Howie

I would like to be able to generate a query via a VBA
call, and would like the actual MS Query interface or a
wizard to allow the user to chose their own data source,
table, and sort criteria. Basically, I'd like to insert
data from a db or text file under program control.
 
You may be able to do something like:

commandbars("Data").Controls("Get External &Data") _
.Controls("Run Save&d Query...").Execute

But you won't be able to maintain control over the process.

You might have to build your own interface and the setup the parameters to
the QueryTables.Add method.
 
Back
Top