Export from Access 2003 to XML

Export from Access 2003 to XML

Post by RnJhbm » Thu, 01 Nov 2007 19:29:03


When I execute this -

DoCmd.TransferText acExportHTML, , "tblCOTClaim", "C:\temp\COTClaim.xml", True

I get -

Runtime Error '3027' Cannot update. Database or object is read-only.

Can anyone please tell me what I am doing wrong?

Thanks in anticipation!

1. How do I export XML data from Access 2002/2003 using a macro?

2. Access 2003 VB Code Export Query Failing with Access 2007 user

I have a set of excel export queries I created in an access 2003 DB. Now,
some of my users have upgraded to Access 2007 and are running in to a
"Parameter" error when the execute the "canned" excel export queries I
created for them. My only presumption is that it is due to the fact that I
have hardcoded the export function, to go to an Office 2003 Excel file, and
for whatever reason, Access 2007 cannot handle this.

This make sense? And if so, any suggestions? I suppose if there was an easy
way to test what version of office/excel they are running, I could change the
parameter on the export based upon which Office version they run. Sound
reasonable, and if so, how? Thanks!


3. Can't export from Access 2000 after installing Access 2003

4. Access 2003 Export fails in Access 2007

5. Exporting from Access 2003 & Access 2007 to Excel

6. Exporting report out in Access 2003 format from Access 2007

7. Automatic Exporting of 2003 Messages to MS Access 2003

8. Export Outlook 2003 Email Message To Access 2003 Table

9. Exporting a Report from 2003 Access into 2003 Word

10. Export Access 2003 report to Word 2003 using XP

11. access 2003: reports export to excel 2003

12. Exporting from access 2003 to excel 2003 margins

13. Export data - Access 2003 to Excel 2003

14. Need XML export solution (Excel 2003)

15. Excel 2003 Professional Edition - Exporting XML Data - optional elements