TransferSpreadsheet with SQL String

[naungsai]

Dear folks
In the place of “Table Name” below, I have put the name of one of my sql table.

DoCmd.TransferSpreadsheet acExport, , "qF01", "D:\Stock.xls", True, "Form01"

I want to know whether I could put the sql string like “Select * from qF01”.
Thanks in advance.

 

[Galaxiom]

Double post
http://www.access-programmers.co.uk/forums/showthread.php?t=216175