__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html> <html lang="es" dir="ltr"> <head> <base href="../../../../"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Importar y exportar datos en Base</title> <link rel="shortcut icon" href="media/navigation/favicon.ico"> <link type="text/css" href="normalize.css" rel="Stylesheet"> <link type="text/css" href="prism.css" rel="Stylesheet"> <link type="text/css" href="default.css" rel="Stylesheet"> <script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1"> </head> <body> <header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules"> <button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav> </div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks"> <input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores de todos los módulos" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div> </div></div> <div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication"> <noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript> <a id="bm_id6911546"></a><meta itemprop="keywords" content="bases de datos, importar/exportar"> <meta itemprop="keywords" content="importar,bases de datos"> <meta itemprop="keywords" content="copiando,origen de datos de la hoja de cálculo"> <meta itemprop="keywords" content="insertando,origen de datos de la hoja de cálculo"> <meta itemprop="keywords" content="hoja de cálculo,insertando los registros de origen de datos"> <meta itemprop="keywords" content="origen de datos,copiando registros para la hoja de cálculo"> <meta itemprop="keywords" content="pegando,desde el origen de datos a LibreOffice Calc"> <h1 id="hd_id4547257" dir="auto"> <a id="data_im_export"></a>Importar y exportar datos en Base</h1> <p id="par_id2761314" class="paragraph" dir="auto">Un método sencillo para importar y exportar tablas de base de datos emplea Calc como aplicación auxiliar.</p> <h2 id="hd_id3912778" dir="auto">Exportar datos desde Base</h2> <p id="par_id3163853" class="paragraph" dir="auto">Se copia una tabla de Base a una hoja de Calc y, a continuación, se pueden guardar o exportar los datos en cualquier formato de archivo compatible con Calc.</p> <ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto"> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id121158" class="paragraph" dir="auto">Abra el archivo de base de datos que contiene la tabla que desee exportar. Pulse en Tablas o en Consultas para mostrar las tablas o las consultas, respectivamente.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id4644306" class="paragraph" dir="auto">Diríjase a <span class="emph">Archivo ▸ Nuevo ▸ Hoja de cálculo</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id1331217" class="paragraph" dir="auto">En la ventana de Base, pulse con el botón secundario del ratón en el nombre de la tabla que quiera exportar. Seleccione <span class="emph">Copiar</span> en el menú contextual.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3806878" class="paragraph" dir="auto">Pulse en la celda A1 en la ventana nueva de Calc y seleccione <span class="emph">Editar ▸ Pegar</span>.</p> </li> </ol> <p id="par_id130619" class="paragraph" dir="auto">Ahora puede guardar o exportar los datos en muchos tipos de archivo.</p> <h2 id="hd_id9999694" dir="auto">Importar datos en Base</h2> <div class="note"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div> <div class="notetext"><p id="par_id8494521" dir="auto">Puede importar documentos de texto, hojas de cálculo y la libreta de direcciones del sistema en modo de solo lectura.</p></div> </div> <br> <div class="note"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div> <div class="notetext"><p id="par_id9579760" dir="auto">Cuando realice importaciones de datos a partir de un archivo de texto o de libro, este archivo debe contener una primera fila cuya información funcione como cabecera. La segunda fila del archivo se tratará como la primera fila con datos. El formato de cada campo de la segunda fila determinará el formato de toda la columna correspondiente. Se perderá el formato durante la importación a Base.</p></div> </div> <br> <div class="note"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div> <div class="notetext"><p id="par_id325632" dir="auto">Por ejemplo, para asegurarse de que el formato de la primera columna sea de texto, debe comprobar que el primer campo de la primera fila de datos válida contenga texto. Si contuviese un número, toda la columna adquirirá el formato numérico y únicamente aparecerán números allí.</p></div> </div> <br> <ol itemprop="HowTo" itemscope="true" itemtype="http://schema.org/HowToSection" dir="auto"> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id2216559" class="paragraph" dir="auto">Abra un archivo de Base del tipo de base de datos que desee.</p> <p id="par_id7869502" class="paragraph" dir="auto">Puede crear un archivo nuevo de Base mediante el <a target="_top" href="es/text/sdatabase/dabawiz01.html">asistente para bases de datos</a> o abrir un archivo de Base existente que no sea de solo lectura.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id9852900" class="paragraph" dir="auto">Abra el archivo de Calc que contiene los datos que se importarán en Base. Puede abrir archivos *.dbf de dBASE, o bien, muchos otros tipos de archivos.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3791924" class="paragraph" dir="auto">Seleccione los datos que quiera copiar en Base.</p> <p id="par_id6173894" class="paragraph" dir="auto">Puede especificar un intervalo de celdas, como A1:X500, en el cuadro Nombre, si no desea desplazarse por el documento.</p> <p id="par_id533768" class="paragraph" dir="auto">Si copia una hoja de dBASE, incluya la fila superior que contiene los datos de la cabecera.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id5669423" class="paragraph" dir="auto">Seleccione <span class="emph">Editar ▸ Copiar</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3619495" class="paragraph" dir="auto">En la ventana de Base, pulse en <span class="emph">Tablas</span> para ver las tablas.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id1175572" class="paragraph" dir="auto">En la ventana de Base, seleccione <span class="emph">Editar ▸ Pegar</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id4815820" class="paragraph" dir="auto">Se abrirá el cuadro de diálogo Copiar tabla. Muchas bases de datos necesitan una clave principal, por lo que es recomendable activar la casilla <span class="emph">Crear clave principal</span>.</p> </li> </ol> <div class="tip"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="tip" style="width:40px;height:40px;"></div> <div class="notetext"><p id="par_id2584002" dir="auto">En sistemas Windows, también puede arrastrar y colocar en lugar de copiar y pegar. Para bases de datos registradas, puede abrir el navegador de orígenes de datos (oprima <span id="swlnsystextsharedguidedata_im_exportxhp_1" class="switchinline"><span hidden="true" id="MACtextsharedguidedata_im_exportxhp_1" class="MAC">⌘⇧F4</span><span hidden="true" id="defaulttextsharedguidedata_im_exportxhp_1">Ctrl + Mayús + F4</span></span>) en lugar de abrir la ventana de Base.</p></div> </div> <br> <a id="relatedtopics"></a><div class="relatedtopics"> <p class="related" itemprop="mentions" dir="auto"><a id="related"></a><span class="emph">Temas relacionados</span></p> <div class="relatedbody" itemprop="mentions"> <p id="par_id5871761" class="paragraph" dir="auto"> <a target="_top" href="es/text/sdatabase/main.html">Utilizar bases de datos en LibreOffice Base</a> </p> <p id="par_id6531266" class="paragraph" dir="auto"> <a target="_top" href="es/text/shared/guide/database_main.html">Información general sobre las bases de datos</a> </p> <div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/dbase_files.html">Importar y exportar archivos dBASE</a></p></div> <div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/csv_files.html">Abrir y guardar archivos de texto CSV</a></p></div> </div> </div> </div> <div id="DonationFrame"></div> <footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2> <div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;"> <img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;"> </div> <div id="DEBUG" class="debug"> <h3 class="bug">Help content debug info:</h3> <p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/shared/guide/data_im_export.xhp" target="_blank">/text/shared/guide/data_im_export.xhp</a></p> <p dir="auto">Title is: Importar y exportar datos en Base</p> <p id="bm_module" dir="auto"></p> <p id="bm_system" dir="auto"></p> <p id="bm_HID" dir="auto"></p> </div></footer> </body> </html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| aaa_start.html | File | 7.35 KB | 0644 |
|
| accessibility.html | File | 9.35 KB | 0644 |
|
| active_help_on_off.html | File | 6.87 KB | 0644 |
|
| activex.html | File | 9.33 KB | 0644 |
|
| assistive.html | File | 8.15 KB | 0644 |
|
| auto_redact.html | File | 9.74 KB | 0644 |
|
| autocorr_url.html | File | 10.32 KB | 0644 |
|
| autohide.html | File | 8.1 KB | 0644 |
|
| background.html | File | 6.44 KB | 0644 |
|
| border_paragraph.html | File | 9.28 KB | 0644 |
|
| border_table.html | File | 9.17 KB | 0644 |
|
| breaking_lines.html | File | 8.14 KB | 0644 |
|
| builtin_help.html | File | 12.61 KB | 0644 |
|
| change_title.html | File | 5.56 KB | 0644 |
|
| chart_axis.html | File | 6.15 KB | 0644 |
|
| chart_barformat.html | File | 6.35 KB | 0644 |
|
| chart_insert.html | File | 10.73 KB | 0644 |
|
| chart_legend.html | File | 6.28 KB | 0644 |
|
| chart_title.html | File | 6.91 KB | 0644 |
|
| classification.html | File | 16.19 KB | 0644 |
|
| cmis-remote-files-setup.html | File | 22.95 KB | 0644 |
|
| cmis-remote-files.html | File | 14.83 KB | 0644 |
|
| collab.html | File | 15.43 KB | 0644 |
|
| configure_overview.html | File | 5.56 KB | 0644 |
|
| contextmenu.html | File | 5.53 KB | 0644 |
|
| convertfilters.html | File | 115.79 KB | 0644 |
|
| copy_drawfunctions.html | File | 7.29 KB | 0644 |
|
| copytable2application.html | File | 7.31 KB | 0644 |
|
| copytext2application.html | File | 8.95 KB | 0644 |
|
| csv_params.html | File | 52.56 KB | 0644 |
|
| ctl.html | File | 9.93 KB | 0644 |
|
| data_addressbook.html | File | 9.53 KB | 0644 |
|
| data_dbase2office.html | File | 8.96 KB | 0644 |
|
| data_enter_sql.html | File | 7.98 KB | 0644 |
|
| data_forms.html | File | 7.65 KB | 0644 |
|
| data_im_export.html | File | 11.67 KB | 0644 |
|
| data_new.html | File | 5.43 KB | 0644 |
|
| data_queries.html | File | 7.17 KB | 0644 |
|
| data_register.html | File | 7.13 KB | 0644 |
|
| data_report.html | File | 8.25 KB | 0644 |
|
| data_reports.html | File | 11.21 KB | 0644 |
|
| data_search.html | File | 5.63 KB | 0644 |
|
| data_search2.html | File | 10.34 KB | 0644 |
|
| data_tabledefine.html | File | 8.53 KB | 0644 |
|
| data_tables.html | File | 8.31 KB | 0644 |
|
| data_view.html | File | 5.85 KB | 0644 |
|
| database_main.html | File | 7.69 KB | 0644 |
|
| dev_tools.html | File | 16.93 KB | 0644 |
|
| digital_signatures.html | File | 14.99 KB | 0644 |
|
| digitalsign_receive.html | File | 8.96 KB | 0644 |
|
| digitalsign_send.html | File | 14.33 KB | 0644 |
|
| doc_autosave.html | File | 10.32 KB | 0644 |
|
| doc_open.html | File | 8.86 KB | 0644 |
|
| doc_save.html | File | 10.47 KB | 0644 |
|
| dragdrop.html | File | 9.65 KB | 0644 |
|
| dragdrop_beamer.html | File | 9.89 KB | 0644 |
|
| dragdrop_gallery.html | File | 7.66 KB | 0644 |
|
| dragdrop_graphic.html | File | 8.06 KB | 0644 |
|
| dragdrop_table.html | File | 7.94 KB | 0644 |
|
| edit_symbolbar.html | File | 7.36 KB | 0644 |
|
| email.html | File | 6.92 KB | 0644 |
|
| error_report.html | File | 7.26 KB | 0644 |
|
| export_ms.html | File | 6.87 KB | 0644 |
|
| fax.html | File | 8.58 KB | 0644 |
|
| filternavigator.html | File | 7.3 KB | 0644 |
|
| find_attributes.html | File | 9.14 KB | 0644 |
|
| flat_icons.html | File | 5.75 KB | 0644 |
|
| floating_toolbar.html | File | 11.42 KB | 0644 |
|
| fontwork.html | File | 11.92 KB | 0644 |
|
| formfields.html | File | 9.28 KB | 0644 |
|
| gallery_insert.html | File | 11.82 KB | 0644 |
|
| graphic_export_params.html | File | 17.53 KB | 0644 |
|
| groups.html | File | 10.49 KB | 0644 |
|
| hyperlink_edit.html | File | 9.48 KB | 0644 |
|
| hyperlink_insert.html | File | 7.17 KB | 0644 |
|
| hyperlink_rel_abs.html | File | 10.62 KB | 0644 |
|
| imagemap.html | File | 13.09 KB | 0644 |
|
| import_ms.html | File | 10.63 KB | 0644 |
|
| insert_bitmap.html | File | 15 KB | 0644 |
|
| insert_graphic_drawit.html | File | 13.7 KB | 0644 |
|
| insert_specialchar.html | File | 9.06 KB | 0644 |
|
| integratinguno.html | File | 6.51 KB | 0644 |
|
| keyboard.html | File | 51.55 KB | 0644 |
|
| labels.html | File | 8.93 KB | 0644 |
|
| labels_database.html | File | 8.23 KB | 0644 |
|
| language_select.html | File | 21.74 KB | 0644 |
|
| line_intext.html | File | 11.89 KB | 0644 |
|
| lineend_define.html | File | 6.32 KB | 0644 |
|
| linestyle_define.html | File | 7.01 KB | 0644 |
|
| linestyles.html | File | 6.43 KB | 0644 |
|
| lotusdbasediff.html | File | 31.13 KB | 0644 |
|
| macro_recording.html | File | 10.49 KB | 0644 |
|
| main.html | File | 25.2 KB | 0644 |
|
| manage_templates.html | File | 16.02 KB | 0644 |
|
| measurement_units.html | File | 7.09 KB | 0644 |
|
| microsoft_terms.html | File | 11.14 KB | 0644 |
|
| ms_doctypes.html | File | 6.26 KB | 0644 |
|
| ms_import_export_limitations.html | File | 15.09 KB | 0644 |
|
| ms_user.html | File | 14.94 KB | 0644 |
|
| navigator.html | File | 6.71 KB | 0644 |
|
| navigator_setcursor.html | File | 7.08 KB | 0644 |
|
| navpane_on.html | File | 5.24 KB | 0644 |
|
| numbering_stop.html | File | 10.09 KB | 0644 |
|
| openpgp.html | File | 15.36 KB | 0644 |
|
| pageformat_max.html | File | 6.76 KB | 0644 |
|
| paintbrush.html | File | 14.25 KB | 0644 |
|
| palette_files.html | File | 11.06 KB | 0644 |
|
| pasting.html | File | 8.59 KB | 0644 |
|
| pdf_params.html | File | 67.4 KB | 0644 |
|
| print_blackwhite.html | File | 12.56 KB | 0644 |
|
| print_faster.html | File | 7.44 KB | 0644 |
|
| protection.html | File | 12.83 KB | 0644 |
|
| redaction.html | File | 11.34 KB | 0644 |
|
| redlining.html | File | 7.45 KB | 0644 |
|
| redlining_accept.html | File | 8.25 KB | 0644 |
|
| redlining_doccompare.html | File | 7.99 KB | 0644 |
|
| redlining_docmerge.html | File | 7.29 KB | 0644 |
|
| redlining_enter.html | File | 9.78 KB | 0644 |
|
| redlining_navigation.html | File | 6.77 KB | 0644 |
|
| redlining_protect.html | File | 6.76 KB | 0644 |
|
| redlining_versions.html | File | 5.8 KB | 0644 |
|
| round_corner.html | File | 5.8 KB | 0644 |
|
| scripting.html | File | 21.23 KB | 0644 |
|
| space_hyphen.html | File | 8.69 KB | 0644 |
|
| spadmin.html | File | 8.97 KB | 0644 |
|
| standard_template.html | File | 15.1 KB | 0644 |
|
| start_parameters.html | File | 46.46 KB | 0644 |
|
| startcenter.html | File | 10.56 KB | 0644 |
|
| tabs.html | File | 14.58 KB | 0644 |
|
| template_manager.html | File | 31.01 KB | 0644 |
|
| text_color.html | File | 6.78 KB | 0644 |
|
| textmode_change.html | File | 7.04 KB | 0644 |
|
| undo_formatting.html | File | 9.17 KB | 0644 |
|
| usingthemes.html | File | 8.26 KB | 0644 |
|
| version_number.html | File | 5.15 KB | 0644 |
|
| viewing_file_properties.html | File | 6.81 KB | 0644 |
|
| workfolder.html | File | 7.05 KB | 0644 |
|
| xforms.html | File | 8.77 KB | 0644 |
|
| xsltfilter.html | File | 8.09 KB | 0644 |
|
| xsltfilter_create.html | File | 14.42 KB | 0644 |
|
| xsltfilter_distribute.html | File | 7.4 KB | 0644 |
|