I am trying to transfer data using below query. many columns in the below query have got dates in date format. When I transfer below query, I am getting attached message window. how can I stop this window from popping up? Also, I created a table using below given query (QryReportDetailMkQry) and replace the query name with table name in blow script. The script does not output the dataset into the Reports.xlsx
Public Sub Export()
ilDatCretd = FileDateTime("path"
DoCmd.TransferSpreadsheet acExport, 10, "QryReportDetailQry", "C:\NtRp\Reports\Reports.x
lsx", True, "RprtDtl" & "." & Format(FilDatCretd, "ddmmyy hhmm")