G
Guest
I am trying to export a query to Excel 2000 using TransferSpreadSheet
function but it fails with error3027 ' Cannot update, database or object is
read-only'.
My code is below....
n.b. qry_JapanResale_kg_SKU_Mth is a crosstab query
Also the path I specified exists...
Function Macro1()
DoCmd.TransferSpreadsheet acExport, 8, "qry_JapanResale_kg_SKU_Mth",
"""K:\market\SDW\Japan Resale\test.xls""", True, ""
End Function
Alrternatively if I go directly to my query, right click export and save as
Excel 97-2000 then it works.
Why doesn't TransferSpreadSheet do the same?
Bruce
function but it fails with error3027 ' Cannot update, database or object is
read-only'.
My code is below....
n.b. qry_JapanResale_kg_SKU_Mth is a crosstab query
Also the path I specified exists...
Function Macro1()
DoCmd.TransferSpreadsheet acExport, 8, "qry_JapanResale_kg_SKU_Mth",
"""K:\market\SDW\Japan Resale\test.xls""", True, ""
End Function
Alrternatively if I go directly to my query, right click export and save as
Excel 97-2000 then it works.
Why doesn't TransferSpreadSheet do the same?
Bruce