What I usually do is use the following to export a query directly into Excel: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, <queryname>, etc. etc.
Is this helpful?
I have some workflow rules in place, but have managed to make them inaccessible using the workflow manager. Some settings on the server have been changed (date/time format) and in CRM, and now whenever I start the workflow manager I get the following error:
---------------------------
An error...
Hi Alex,
it is always suggested that you can't access the SQL database of CRM directly, but that's not true. I use an ODBC link from Access to create some simple reports directly on the database tables. I hope this helps you.
Regards, Yvonne
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.