how to export Access 2010 data macros

ms-access macros ms-access-2010 ms-access-data-macro
unrazzle picture unrazzle · Feb 9, 2012 · Viewed 8.3k times · Source

I need to transfer Access data macros from my test db to my production db. Anybody know how to do that?

I know that transferring tables from one accdb to another will also transfer the data macros, but that's not an option in my case. I also know I can recreate them manually in the production accdb, but that leaves me open to errors and requires taking the production database down for a longer time than would a scripted transfer scenario.

If I only had to do this once it wouldn't be such a big deal, but I'll need to do it many times over the course of a development project.

I've tried exporting the tables to xml, but the data macros are not included.

Please note that I'm asking about Access 2010 data macros here, not regular Access macros.

Answer

Lanik picture Lanik · Oct 27, 2012

You may want to try a pair of undocumented VBA functions

To export:

SaveAsText acTableDataMacro, "TableName", "C:\PathToFile\DataMacro.xml"

To import:

LoadFromText acTableDataMacro, "TableName", "C:\PathToFile\DataMacro.xml"

Related questions

How can I schedule a Macro to run automatically in Access 2007

I'd like to have a macro, called Macro1, for example, run every day at 9 AM. It works great on its own from the VB code editor in Access 2007 but I would like it to be able to execute automatically without …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Sum(tbl1.fld1 + tbl1.fld2) AS [Total] …

Read More