I am using access 2007 and it requires a few self editing steps to make variations work. for example after my query, I have to add a command line for each item that has variation.  The ones that doesn't have variation, I do not have to mess with.

I was wondering if there is any other database program that has the ability to just export a query and have a working FE upload file for variations.