[AccessD] Exporting table to a word doc

Rocky Smolin rockysmolin2 at gmail.com
Tue Aug 15 12:09:18 CDT 2023


Dear List(s):

I have a very simple requirement to export a table with records of one
field - field is text format. I use:

    DoCmd.TransferText acExportDelim, , "tblLeaseToWord",
"C:\Clients\AGR\Temp\Lease.docx"

I get the error message "Cannot Update. Database or object is read-only."

I tried it with the doc file \Lease.docx already created, empty and without
the doc file present. ICn  assume if I can get this to work the doc file
will be created by the export? Doesn't need to pre-exist the TransferText?

What's the fix for this? Or  is there a better way to export the records in
this table?

MTIA,

Rocky


More information about the AccessD mailing list