Ask Your Question

Base: Select and copy specific columns from query results

asked 2019-01-02 18:42:22 +0100

dave31175 gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-02 22:22:08 +0100

Ratslinger gravatar image


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.

edit flag offensive delete link more


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 :(

dave31175 gravatar imagedave31175 ( 2019-01-02 22:26:44 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-02 18:42:22 +0100

Seen: 20 times

Last updated: Jan 02