Output to xls

[KenHigg]

I have a sql string that is used to populate a form and now I'd like to export that set of records to a spreadsheet but I can't get 'OutputTo' to work. It wants a predefined query name - !? Any suggestions?

 

[mhartman]

In Access, saved your SQL statement as a query. It should then work.

Regards
Mark

 

[mhartman]

View, Design View, File Save As

 

[KenHigg]

I build the sql string in code and the set a forms recordsource to the sql string. What command do you use to save a sql string as a query?

 

[KeithG]

First just create a query object so that you can manipulate the SQL. Then you can open the querydef in code and update the SQL Statement. Something like below would work or at least give you and idea

Dim def As QueryDef

Set def = CurrentDb.QueryDefs("queryName")

def.SQL = "SQLstring"

 

[KenHigg]

Thanks Mark & Keith - I got this to work with the QueryDef thing -