Currently I use 'OutputTo' to export out queries to Excel, but I seem to have hit a row limitaion because this one query has 25K rows and Access won't export it. (Error: There are too many rows to output, based on the limitation specified by the output format or by Microsoft Access).
Now, within my macro, the 'Output Format' section lists the basic Microsoft Excel (*.xls), which I want, but when I select it, Access changes it to Microsoft Excel 5-7 (*.xls). I think this is what's causing the problem but I don't know how to get around it.
So now I'm thinking of using the TransferSpreadsheet instead, but the users of this need to be able to save these queries to different locations so....Is there a way to have transferspreadsheet pull a 'save as' window instead of just saving it to the same location everytime?
Thanks.
Now, within my macro, the 'Output Format' section lists the basic Microsoft Excel (*.xls), which I want, but when I select it, Access changes it to Microsoft Excel 5-7 (*.xls). I think this is what's causing the problem but I don't know how to get around it.
So now I'm thinking of using the TransferSpreadsheet instead, but the users of this need to be able to save these queries to different locations so....Is there a way to have transferspreadsheet pull a 'save as' window instead of just saving it to the same location everytime?
Thanks.