I used to use Access 2010 quite a bit, not so much anymore. It is, well, different.
What it isn’t is a spreadsheet program or a text editing program. It tries to be a database program, and does a pretty good job of that, but not a great one. Now, I am not a programmer or an IT guy. I’m an engineer and the only computer courses I had in college was Basic and Fortran (actually WATFIV, if that means anything to anyone, anymore) and had less than a year of that, combined.
I am not sure what you are trying to do, but I don’t think Access is the right tool. It might be, but if you are going to use it, you really need to learn it.
When I first started using Access, I was working on a migration from Dbase (I think? It was in the last millennium) as the company had decided to go with Microsoft for all it’s software needs. Anyway, I wasn’t very familiar with the Dbase program, so I had that working for me. An intern and I (the intern did most of the work) got the system up and running, then the intern was gone and I had to keep it going. Day-to-day operation was performed by a clerk, but I had to trouble-shoot and keep it running.
I was familiar with Excel and Word, and somewhat knowledgeable on their macros, so I thought it wouldn’t be that much trouble. It wasn’t until I had a technician set-up a separate computer for some testing equipment that used Access to store the data (completely, well, mostly, unrelated to the other application) that I gained a better understanding. He said something that really sank in. We were doing something with a table and he said “This isn’t a spreadsheet, you are actually in the database. The table is just how it is displaying the information.”
Again, I have no idea what you are trying to do, or how you are going about it, but if you are trying to make (format) the table to present the data in a particular way and then export it to preserve how you have formatted it, you are doing it wrong. If you want to export formatted data, say in a text file, than I think you have to create a “query” to pull the data you want, in the order you want, from a “table” and make a “report” formatting the data the way you want and write the report to a file. Again, this is assuming that is what you want to do. It is a lot more complicated than it needs to be because it doesn’t sound as if you really need a database program to do what you are trying to do.