I tried to export my query results into MS Excel. The data was exported correctly. The problem is that when I ran the query again and error is now displayed. "Query must have at least one destination field"
How can this have happened?
I tried to export my query results into MS Excel. The data was exported correctly. The problem is that when I ran the query again and error is now displayed. "Query must have at least one destination field"
How can this have happened?
How are you exporting? What are the exact steps you are taking?
steps:
1. right click on the query at the sidebar.
2. select export
3. select excel
4. in the wizard, select filename
5. select save data format
6. proceed to export
same result if we use the export button in ribbon
Do you have the the query open at all during this? Have you saved the query before doing this? Do you have Service Pack 1 for EITHER Windows 7 or Office 2010 installed?
Does it happen on only this database or in any of them?
i have saved the query already and closed the query before exporting. i have the latest service packs for my windows 7 and office 2010.
also if i tried not to save the data format the problem does not occur
It might be a bug in Access or the SP1. Can you upload a copy of it so I can test it in a non SP1 environment?
Any news in this?
I have the same problem in a Windows 2003 Server x86 with Access 2003. There are some annoying details:
I have three MDB files that do the same, just in different paths. 2 out of 3 started to suffer this bug. I've made things like compare/repair, or totally deleting the queries/macros that auto export and making them again manually. But the heaviest thing I've tried is to copy the MDB that does work fine, and change the paths of the linked tables/export paths to "convert" the one that works in the ones that fail. But when I do that, it starts failing too.
I don't have a clue about it.