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