Exporting in code as a spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why doesn't the following work, but stop with a run-time error 3027 'cannot
update. database or object is read only

strPath="C:\Data\GSEXP\"
strFile="21WS.CSV"
strQryNm="qryOutPut"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strQryNm,
strPath & strFile, True
 
Back
Top