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
Steve Medvid
Systems Analyst
Environmental Resource Management