The Access query produces:
| 'dead' | 'Category' |
|---|---|
| 671 | FAM |
| 357 | FAMNONRES |
| 15 | PRIV |
| 5970 | PUB |
| 169 | RES |
| 124 | SCHOOL |
| 18 | UNKNOWN |
| 165 | WORK |
| 12 | WORSHIP |
but imported into Excel all the Category names turn into numbers:
| SumOfdead | cause | |
| 6 | 4 | |
| 3 | 5 | |
| 2 | 8 | |
| 3 | 10 | |
| 11 | 18 | |
| 3 | 20 | |
| 3 | 24 | |
And no, I cannot write a book in SQL queries.
Figured it out. I imported from the old database, not the new one.
It is clumsy. Link from Excel to Access query results. Create graph from data in Excel. Link from Word to Excel objects.
Make a report of your table, and export that. Exporting directly tables and queries in any dbs is not a great plan.If I was staying at home, I'd offer to assist, but I am in an Essential Occupation.
ReplyDeleteI've never used Access (and barely use Word or Excel) but have you tried exporting the data as a CSV file? It's my dim recollection that CSV is a useful lingua franca for tasks like yours.
ReplyDeleteI think (from Googling) that you can import CSV files into Word tables without using Excel as an intermediate step, but I haven't tried that myself.
Export/import is clumsy compared to how Word automatically updates from a spreadsheet.
ReplyDeleteOkay. How about mail merge? I *really* haven't tried that, but ... "you can use the mail merge feature to merge any kind of data with Word, such as inventory records, tasks, or whatever you store in Access."
ReplyDeletehttps://support.microsoft.com/en-us/office/use-mail-merge-to-send-access-data-to-word-053cc639-fe30-4d3a-943d-0bee0892f16a?ui=en-us&rs=en-us&ad=us