I just made all the data/ tables I wanted to export into querys, and that works to export the data as a copy and not a just a link. But it creates another problem. I have a couple long text fields in some of my tables that are also formatted as Rich text fields. So I can make text bold and different colors. When I export the data through the query it loses the Rich text formatting, then it has all the HTML tags in the text. When I export the data directly from the table it doesn't lose the Rich Text formatting. I tried setting the Query format to RTF for that data field but it still lost the Rich Text formatting (Has the HTML tags in the text).
I would prefer to just export the data directly from the tables, but it keeps on only exporting the link and not a copy of the table, when I do that. I think it has to do with the file I am using is a front end file and the tables are just linked in the access file I am using to export the data.
Is there a way with VBA code to automatically make table a local copy and not a linked copy? I know how to make the table a local copy within the database, but I want it to automatically do this after it exports the tables.