Applying Transfer Text

Topic

New Reply

when i try to do this:

DoCmd.TransferText acExportDelim, “”, “RUGItemChangeTable”, FilePath & “MLRAMLRA_Changes.xls”, True, “”

i get the error “Database or Object is read-only”

I can get the data out using

DoCmd.OutputTo acTable, “RUGItemChangeTable”, “MicrosoftExcelBiff8(*.xls)”, FilePath & “MLRAMLRA_Changes.xls”, False, “”, 0

in other news, this works:

DoCmd.TransferText acExportDelim, , “EditMDS”, FilePath & “MLRAMLRA.txt”, True

Weird! I’d like to use transfer text as there is a (somewhat remote) chance that the data could exceed the row amount in Excel (2003).

Reply | Quote

Replies

when i try to do this:

DoCmd.TransferText acExportDelim, “”, “RUGItemChangeTable”, FilePath & “MLRAMLRA_Changes.xls”, True, “”

i get the error “Database or Object is read-only”

I can get the data out using

DoCmd.OutputTo acTable, “RUGItemChangeTable”, “MicrosoftExcelBiff8(*.xls)”, FilePath & “MLRAMLRA_Changes.xls”, False, “”, 0

in other news, this works:

DoCmd.TransferText acExportDelim, , “EditMDS”, FilePath & “MLRAMLRA.txt”, True

Weird! I’d like to use transfer text as there is a (somewhat remote) chance that the data could exceed the row amount in Excel (2003).

I noticed that aside form trying to export different tables, the 2 “TransferText” lines have another difference! The 2nd option (the “Specification Name” is “” in the first instance, and Null in the 2nd.

Reply | Quote

that’s true but i’ve been using the same syntax as the second, working code. the only reason there’s the empty quotes is, i copy/pasted the VB code generated from a converted macro – which works in a new, empty DB but not on the one i am using. When i write the macro on the target DB, not only doesn’t it run but it won’t convert to VB.

In any case, I don’t think that is the issue – the same error occurs with or without the empty quotes.

Reply | Quote