Base: Select and copy specific columns from query results

[dave31175]

As part of my workflow, in MSAccess, I would frequently copy only certain columns from a query result by clicking and dragging across the column headers to select, then Ctrl-C to copy ONLY those columns to the clipboard. Additionally, I frequently select only one column by clicking on the colunn header, then copying to clipboard. In Base, such basic functionality is eluding me. Copying query results appears to be an all or nothing proposition. I can select a single column but cannot copy it to the clipboard. I cannot select multiple columns.

Is there some way to accomplish what I need? Thanks.

[Ratslinger]

Hello,

See no method of doing this in Base. With a registered database you can use Calc and select what is wanted using ‘Data Sources’. Once you have columns needed placed on the sheet, you can copy/paste.

Depending upon the database being used you could also use SQL Workbench/J to do what you want.

[dave31175]

Thanks @Ratslinger. I’ll look into the Calc Data Sources option. I’m quite astonished that such basic functionality doesn’t exist. This may well be the dealbreaker that forces me to continue my reliance on MSAccess