Exporting in code as a spreadsheet

J

Jack

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import password protected excel sheets 0
Import password protected excel files 0
Problem exporting multiple tables into different worksheets in oneworkbook 3
Importing excel spreadsheet with changed data 1
adding a run macro function 0
Select Folder and Import from all Excel files in Folder 4
how to import multiple Excel files into multiple Access tables? 9
Select a Folder for Access 2007 Table Export 15

Top