__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ 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 formato de texto</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_id3157896"></a><meta itemprop="keywords" content="bases de datos,formatos de texto"> <meta itemprop="keywords" content="formatos de texto,bases de datos"> <meta itemprop="keywords" content="importar,tablas en formato de texto"> <meta itemprop="keywords" content="exportar,hojas de cálculo a formato de texto"> <h1 id="hd_id3154824" dir="auto"> <a id="data_dbase2office"></a>Importación y exportación de datos en formato de texto</h1> <p id="par_id3147088" class="paragraph" dir="auto">Si quiere intercambiar datos con una base de datos que no tiene un enlace ODBC y no permite importar o exportar archivos dBASE, es posible usar un formato de texto en común.</p> <h2 id="hd_id3145313" dir="auto">Importación de datos a LibreOffice</h2> <p id="par_id3147275" class="paragraph" dir="auto">Para intercambiar datos con un formato de texto, utilice el filtro de importación y exportación de LibreOffice 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_id3145382" class="listitem" dir="auto">Exporte los datos que desee desde la base de datos fuente con formato de texto. El formato de texto CSV se recomienda. Este formato separa los campos de datos usando separadores como puntos y coma o comas, y separa registros insertando saltos de línea.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3153821" class="listitem" dir="auto">Seleccione <span class="emph">Archivo ▸ </span><a target="_top" href="es/text/shared/01/01020000.html"><span class="emph">Abrir</span></a> y pulse en el archivo que desee importar.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id1977904" class="listitem" dir="auto">En el cuadro combinado <span class="emph">Tipo de archivo</span>, seleccione «Texto CSV». Pulse en <span class="emph">Abrir</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3150771" class="listitem" dir="auto">Se abre el diálogo <a target="_top" href="es/text/shared/00/00000208.html"><span class="emph">TImportar texto</span></a>. Decida qué datos desea incluir del documento de texto.</p> </li> </ol> <p id="par_id3150986" class="paragraph" dir="auto">Cuando los datos ya se encuentran en una hoja de cálculo de LibreOffice Calc, los puede editar a su conveniencia. Guarde los datos como origen de datos de LibreOffice:</p> <ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto"> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto"> <p id="par_id3149762" class="listitem" dir="auto">Guarde el libro actual de LibreOffice Calc como un archivo de dBASE dentro de la carpeta de una base de datos dBASE. Para hacerlo, diríjase a <span class="emph">Archivo ▸ Guardar como</span>; en el cuadro <span class="emph">Tipo de archivo</span> elija «dBASE» y luego seleccione la carpeta de la base de datos dBASE.</p> </li> </ul> <h2 id="hd_id3150400" dir="auto">Exportación al formato de texto CSV</h2> <p id="par_id3154140" class="paragraph" dir="auto">La hoja actual de LibreOffice se puede exportar a un formato de texto que podrá ser leído por muchas otras aplicaciones.</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_id3152933" class="listitem" dir="auto">Vaya a <span class="emph">Archivo ▸ Guardar como</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3154216" class="listitem" dir="auto">En el cuadro <span class="emph">Tipo de archivo</span> seleccione el filtro «Texto CSV». Proporcione un nombre de archivo y pulse en <span class="emph">Guardar</span>.</p> </li> <li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/HowToStep" dir="auto"> <p id="par_id3154908" class="listitem" dir="auto">Abre el cuadro de diálogo <a target="_top" href="es/text/shared/00/00000207.html"><span class="emph">Exportación de archivos de texto</span></a>, en el que se pueden seleccionar el conjunto de caracteres, el delimitador de campos y el de texto. Pulse en <span class="emph">Aceptar</span>. Un aviso indica que solo se ha guardado la hoja activa.</p> </li> </ol> <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"> <div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/shared/guide/data_im_export.html">Importar y exportar datos en Base</a></p></div> <span id="swlnappltextsharedguidedata_dbase2officexml_1" class="switch"> <span hidden="true" id="CALCtextsharedguidedata_dbase2officexml_1" class="CALC"><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></span> </span> </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_dbase2office.xhp" target="_blank">/text/shared/guide/data_dbase2office.xhp</a></p> <p dir="auto">Title is: Importar y exportar datos en formato de texto</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 |
|