Val Byref
02-08-2006, 08:33 AM
I and my coworkers have noticed an irritation with exporting to Excel in Access 2003. In earlier versions, you could export the result of multiple queries to Excel without repeatedly having to specify the export format. In other words, after the first export you could go to the next query and Access would "remember" your previous export format. Now, apparently, you must choose the export format each time.
Is there a work around for this or perhaps a setting that I am not aware of?
Of course, I know that we could obviate the problem by handling the exports in code. However, this is for intermediate level users who just want to do this kind of thing on an ad hoc basis.
Thanks in advance for your help with this.
Is there a work around for this or perhaps a setting that I am not aware of?
Of course, I know that we could obviate the problem by handling the exports in code. However, this is for intermediate level users who just want to do this kind of thing on an ad hoc basis.
Thanks in advance for your help with this.