-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 El 2009-04-11 a las 17:28 +0200, Camaleón escribió:
Bueno, gracias a los dos por las sugerencias.
El "pincha-corta-copia-pega" desde Calc que comentaba Carlos E. R. inicia el asistente de configuración para la importación de datos. Todo bien, hasta que ves el resultado de la importación en la tabla MySQL: no lo exporta correctamente, sólo importa números cuando se trata de texto.
Ah, vaya. Creo que con la hoja de calculo pasa lo mismo, pero puedes ir columna por columna en la previsualización cambiando el tipo, antes de importar. Prueba rekall, dice que soporta csv en lectura directa: Comma Separated Values The CSV driver allows Rekall to directly access data stored in comma-separated-value files. You should bear in mind however that this is not really a "database" and that there are a lot of restrictions. The main use of this driver is as an alternative to the CSV data copier; note that the driver is read-only, so files cannot be updated. Rekall treats a set of CSV files (ie., those files whose name ends with .csv) in a particular directory as the "database"; the directory is specified in the database setting of the database connection. The name of the file, with the .csv suffix stripped, is used as the table name. There are three settings under the advanced tab. The delimiter and the qualifier provide the usual separator values, and default to the comma character and single quotes respectively. The header setting specifies whether the first line in the file is treated as column names; if not then the columns are named column1, column2, etc. Currrently, the SQL which can be used with the CSV driver is extremely limited. You can use where conditions, but group, having and order are not supported. Select queries may only contain a single table (ie., table join is not supported). Only very basic expressions are possible; basic operations like addition and subtraction, and comparisoms. There are no automatic type conversions and all columns appear as strings. Type conversion is available via the tochar, toint and todouble functions. If is hoped to extend the SQL to be the same as supported by the XBase driver in a future release. No tengo ahora mismo un fichero .csv para probar, y tampoco sé si tengo instalado el plugin. También soporta importar del access: MDB Formatted File Driver This driver provides read-only access to MDB files, as produced by the MicroSoft Access(tm) database. It uses the MDBTOOLS library (see http://mdbtools.sourceforge.net/) and has the limitations of that library. The MDB file is specifed in the database setting of the database connection. Currrently, the SQL which can be used with the CSV driver is extremely limited, and is the same as for the CSV driver, except that column type information is used. If is hoped to extend the SQL to be the same as supported by the XBase driver in a future release, and/or to use the SQL layer which is being developed as part of MDBTOOLS. Note that this drived requires at least the 0.6 pre-release MDB code; it will not build with the 0.5 release.
En fin, que he descargado SQuirreL SQL (me parece que Base no está muy fino para ésto), a ver qué tal se le dá la importación desde archivos en texto plano.
Ya contarás. - -- Saludos Carlos E.R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAkng8BEACgkQtTMYHG2NR9UtdgCdGCp8BrKellfx3EyeAMZBZv/o Bp4An3N0nrdGlY+ZZ5CrtCJssBJQ1Ygb =s5AM -----END PGP SIGNATURE-----