export to spreadsheet, how to use recordset or query 1

[1DMF]

Hi,

I've got my query string working, and I would like to use the query to export records as a spreadsheet.

The problem I am having is it seems the

DoCmd.TransferSpreadsheet acExport,

command is expecting a tablename to be supplied, yet I want to use a sql select statement or recordset and it keeps erroring if I use either.

Is it possible to do an export to spreadsheet using another datasource other than a table?

or if not is there an easy way to create a table on the fly based on a sql select statement or recordset that I could then issue the transferspreadsheet against then delete?

Advice on the best approach is appreciated.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!

 

[JerryKlmns]

Is it possible to do an export to spreadsheet using another datasource other than a table?

Try a query!

 

[1DMF]

That gave me an idea, thanks JerryKlmns, I did this...

DoCmd.DeleteObject acQuery, "Export_Prospects"

CurrentDb.CreateQueryDef "Export_Prospects", sSQL

then as you say supplied the query name for the export, works like a dream.

Many thanks 1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!