Pasting Query Data into Excel

[Moxioron]

Hello all.

I have a query that I am trying to copy/paste the contents into an Excel template I built.

The weird part is that when I try to paste the data as text or .csv, it doesn't paste any expressions I have.

If I just straight out paste, it does, but not paste special.

Any ideas how to get around this (I have to paste as text or .csv)?

Thank you.

 

[Trevor G]

Take a look at a DoCmd.TransferSpreadsheet command you can also consider a MACRO which does the TransferSpreadsheet which it the same as the DoCmd.

In your query have you got the tick selected below the expression Field?

 

[tad0075]

Depending on how your users are set up, you could also link your data source to an Excel spreadsheet. You can go to the Data tab in Excel, and the first button on the menu is to get external data "From Access." You should be able to select queries as data sources, and the query results will display in an Excel Table. This works if your database is on a network accessible by your users. You'll probably just have to set the database as a trusted location on their machine and set it to refresh data sources on open.

Good luck,

-Tyler