Export Query Data to a table

All,

I have no clue what I'm doing when it comes to access. We receive files monthly from our client with a general ledger in access format as it is over the excel row max. We use a program called Idea to combine columns based on matching criteria across multiple different files.

The person in charge of creating our files retired from our client recently and no one else knows how to do what they did. The only thing I needed done was on the general ledger, I needed a month column as our Macro in Idea needs this column. I did some research and created the month column so I have all the data needed in one file. Now, all of that data is in a query and when I import the access database into Idea, it is not picking up portion I need as it is in a query, not a table. I tried exporting to a table within the file, and it stays under query. I tried exporting to a different database, stayed as a query.

I tried opening the query, right clicking the top and going in design view, then make table and no matter what I do, no new table is made.

Please help

Sorry, disregard, I got it to work

So please post your solution, as it might help others in the future?

After all, that is what these forums are about?

I think it was because the file was locked, disabling Macros, and not allowing me to create a table.

I also may have just been missing a step. Once the query is done, open the query in Design View, and under query design, select make table. Input your table name and where you want that table to be stored, click ok.

And likely my final misstep, CLICK RUN!

I think I wasn't clicking run earlier, thinking that after the OK, the function would perform.

Thank you.
Likely the missing run was the cause.