1<?xml version="1.0" encoding="UTF-8"?> 2<!-- 3 * This file is part of the LibreOffice project. 4 * 5 * This Source Code Form is subject to the terms of the Mozilla Public 6 * License, v. 2.0. If a copy of the MPL was not distributed with this 7 * file, You can obtain one at http://mozilla.org/MPL/2.0/. 8 * 9 * This file incorporates work covered by the following license notice: 10 * 11 * Licensed to the Apache Software Foundation (ASF) under one or more 12 * contributor license agreements. See the NOTICE file distributed 13 * with this work for additional information regarding copyright 14 * ownership. The ASF licenses this file to you under the Apache 15 * License, Version 2.0 (the "License"); you may not use this file 16 * except in compliance with the License. You may obtain a copy of 17 * the License at http://www.apache.org/licenses/LICENSE-2.0 . 18 --> 19<helpdocument version="1.0"> 20<meta> 21<topic id="textsharedexplorerdatabase05030200xml" indexer="exclude" status="PUBLISH"> 22<title id="tit" xml-lang="en-US">Apply columns</title> 23<filename>/text/sdatabase/05030200.xhp</filename> 24</topic> 25</meta> 26<body> 27<section id="tablecopy2"> 28<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/ApplyColPage" id="bm_id3155806" localize="false"/> 29<h1 id="hd_id3150445"><link href="text/sdatabase/05030200.xhp" name="Apply columns">Apply columns</link></h1> 30<paragraph role="paragraph" id="par_id3147143" xml-lang="en-US">In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The <emph>Apply columns </emph>dialog is the second window of the <emph>Copy table</emph> dialog.</paragraph> 31</section> 32<h2 id="hd_id3155552">Existing columns</h2> 33<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/from" id="bm_id3155805" localize="false"/><h3 id="hd_id3154751">Left list box</h3> 34<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US"><ahelp hid="dbaccess/ui/applycolpage/from">Lists the available data fields that you can include in the copied table. To copy a data field, click its name, and then click the > button. To copy all of the fields, click the <emph>>></emph> button.</ahelp></paragraph> 35<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/to" id="bm_id3149827" localize="false"/><h3 id="hd_id3154823">Right list box</h3> 36<paragraph role="paragraph" id="par_id3156426" xml-lang="en-US"><ahelp hid="dbaccess/ui/applycolpage/to">Lists the fields that you want to include in the copied table.</ahelp></paragraph> 37<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colrh" id="bm_id3152781" localize="false"/> 38<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colsrh" id="bm_id3147653" localize="false"/> 39<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/collh" id="bm_id3151110" localize="false"/> 40<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/applycolpage/colslh" id="bm_id3152996" localize="false"/><h3 id="hd_id3147242">Buttons</h3> 41<paragraph role="paragraph" id="par_id3146797" xml-lang="en-US"><ahelp hid=".">Adds or removes the selected field (> or < button) or all of the fields (<< or >> button).</ahelp></paragraph> 42<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US"><link href="text/sdatabase/05030300.xhp" name="Next page">Next page</link></paragraph> 43</body> 44</helpdocument> 45