I have several make table queries that create an excel file. Each of my queries makes a different sheet in the file. Whenever I go to change something as I work on it and go into design view and save, it will mess up my sql. I always check it right before and after I save and it is there, but if I close it after saving and reopen the query I can see that it deleted the alternate database name in my INTO statement.
Basically it drops the alternate database and just tries to make the table into the excel sheet's name(which goes no where or creates a table in the current datase).
Is there something I can do to keep this from happening everytime I edit in design view? I'm a visual person and sometimes my head hurts looking at SQL and I have to go back to design view to problem solve.
Thanks,