TransferText in xls causes error 3027

[Bob Tindall]

If I do a DoCmd.TransferText to export from a query and
set the export file name to xxxxx.xls I get "Error 3027,
Can't update. Database or object is read only.". The full
line of code is:

DoCmd.TransferText
acExportDelim, "OpenAccountsExportInvoices", "qryOpenAccoun
tsExportTable", sPathname, False

sPathname is a string variable containing a full pathname
including a filename ending in ".xls". If I change this
to ".csv" it exports OK.

I am running WinXP Pro. The error occurs with any version
of Access (Access97, 2000 or XP). It does not occur on
Win98 or Win2K.

Anyone seen this before? I can't find anything in the
knowledge base about it.

Thanks, Bob

 

[Joe Fallon]

Check out the following KB articles for an explanation, and how to get
around it:

ACC97: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q247861

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q245407

ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize (Q306144)
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q306144

 

[Bob]

The problem I have occurs when exporting data.
Unfortuntely these articles are all to do with data import.
Do you think you could try doing a similar export to mine
(using WinXP pro) and see if you get the same problem,
please? - Bob

 

[John Nurick]

The ! at the start of the registry value means that these are the
extensions that are _not_ disabled. If you want to create a text file
with an XLS extension - which I emphatically don't recommend - you'll
need to include xls in the list.

 

[ironwolfbeard]

The ! at the start of the registry value means that these are the
extensions that are not disabled. If you want to create a text file
with an XLS extension - which I emphatically don't recommend - you'll
need to include xls in the list.

The export has to be a file type that MS Access supports. Like .CSV