Read Only Error Message

[tjherman]

I'm using the TransferText function to export a table from Access into Excel. If I export the file as a .txt or a .csv, it works fine; however when I try to export the file as an .XLS, I get a run-time error of 3027 -- "Cannot update. Database or object is read-only."

Here's the code:

DoCmd.TransferText acExportDelim, , "tmpAssociateCharges", "C:\Associate.xls", True

 

[JBinQLD]

sorry for suggesting the obvious, but is associate.xls open in excel at the time?

Excel and Word tend to lock files that are open where .txt files are much more accessable even when open in the wonder application, notepad.

Apologies again for suggesting something so obvious but sometimes these things are the easiest to overlook!

JB

 

[RobertT687]

Take a look at the TransferSpreadsheet function if you are trying to create a spreadsheet directly from Access.

 

[tjherman]

No, the file isn't open. I'm even deleting the file if it exists first.