I have an excel template given to me that requires 340 fields to be filled. I have just realized in the many years of working with access that there is a field limit to an access query. So I cannot do a single query. I then broke it into 2 queries and when I tried to call both the same thing happened it wont combine the results saying to many fields defined.
I am at a loss as to how to grab these fields and export them together. Can it be done doing it in sql code ??? And please before I have someone tell me again about bad construction these are not my planning's. I work between a Healthcare org and Gov't, neither hears no, and usually idiots build this stuff, so I am forced to do what they want if possible. LOL so if there is a way to export from access 340 fields into excel I would be greatly appreciative for the help if possible.
I also thought of doing 2 exports but my fear is that after the first export the second could be missing a rec and the rest would be mismatched and no one could tell.