>I have developed an Access front-end to allow users to create and save queries in an Access database. The front end simply creates the Where clause based on user selections from a variety of list boxes and combo boxes. After gathering the Where clause stuff, I create the entire SQL String. The first part is predefined "Select * from Tables..join..." and the second part is the Where construct. Well, I am able to create a query via CreateQueryDef and export that created query to Excel via OutputTo (DoCmd.OutputTo acOutputQuery, lcQueryName, acFormatXLS, , ViewExcelFlag). But OutPutTo does not offer a DBF export option. Is there anything I missed in the docs about this, short of writing OLE code. tia

-> FYI.
I ended up using the Common dialog control with the TransferDatabase method. - the OutPutTo allows for leaving the export file name to be empty. Then an open file dialog is presented. The TRansferdatabase does not offer this common feature.