Export table to Word merge doc

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I am not sure if this is a MS issue or a security issue
within my office. I am trying to automate the merge of
an access table to an existing word merge doc. I have

docmd.transfertext
acExportMerge, , "tempMerge", "c:\data\merge.doc"

I am getting an error "Cannot Update. Database or Object
is read only"

Our security will not give me administrative rights on my
pc. Could that be causing the error, or is my code wrong?
 
When I renamed it .txt it the merge just deleted the word
form and replaced it with the data from the table I am
exporting in a delimited format.
I have done searchs in the Knowledge base and I have
found the articles on the error but they don't apply in
this case. What this code does in 97 - opens the word
doc and performs the merge and ends with the completed
document open in word ready to be printed or saved.
I have tried making the word form in a .rtf format and it
gives the same error when trying to merge.
Thanks for the ideas though. Finding the chart of
allowed file extensions will be helpful in the future.
-----Original Message-----
Hi Cindy,

This one is almost certainly caused by your filename. Recent versions of
Access require text files to use standard extensions such as .txt and
..csv. The simplest thing is just to call it merge.txt rather than
merge.doc; otherwise this article
http://support.microsoft.com/default.aspx?scid=kb;en- us;304206 shows how
to change the extensions that Access will accept.

I am not sure if this is a MS issue or a security issue
within my office. I am trying to automate the merge of
an access table to an existing word merge doc. I have

docmd.transfertext
acExportMerge, , "tempMerge", "c:\data\merge.doc"

I am getting an error "Cannot Update. Database or Object
is read only"

Our security will not give me administrative rights on my
pc. Could that be causing the error, or is my code
Click to expand...
wrong?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Comments inline.

When I renamed it .txt it the merge just deleted the word
form and replaced it with the data from the table I am
exporting in a delimited format.
Click to expand...

As far as I know this is what's meant to happen:
DoCmd.TransferText acExportMerge
just creates a textfile containing the data with a layout that Word will
be able to import.

Take a look at Albert Kallal's sample mailmerge application at
http://www.attcanada.net/~kallal.msn/wordmerge/index.html. This lets
you set up a one-button merge.

I have done searchs in the Knowledge base and I have
found the articles on the error but they don't apply in
this case. What this code does in 97 - opens the word
doc and performs the merge and ends with the completed
document open in word ready to be printed or saved.
I have tried making the word form in a .rtf format and it
gives the same error when trying to merge.
Thanks for the ideas though. Finding the chart of
allowed file extensions will be helpful in the future.
-----Original Message-----
Hi Cindy,

This one is almost certainly caused by your filename. Recent versions of
Access require text files to use standard extensions such as .txt and
..csv. The simplest thing is just to call it merge.txt rather than
merge.doc; otherwise this article
http://support.microsoft.com/default.aspx?scid=kb;en- us;304206 shows how
to change the extensions that Access will accept.

I am not sure if this is a MS issue or a security issue
within my office. I am trying to automate the merge of
an access table to an existing word merge doc. I have

docmd.transfertext
acExportMerge, , "tempMerge", "c:\data\merge.doc"

I am getting an error "Cannot Update. Database or Object
is read only"

Our security will not give me administrative rights on my
pc. Could that be causing the error, or is my code
Click to expand...
wrong?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top