Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Importar Planilla Excel a MySQL

Started by golf2009 , Oct 14 2010 05:33 AM

Please log in to reply

4 replies to this topic

#1 golf2009

Advanced Member

Miembros
99 posts

Posted 14 October 2010 - 05:33 AM

Hola a todos:
Me están preguntando si existe la posibilidad de hacer un copiar y pegar de una planilla excel a una tabla mysql.
Es posible?
Desde ya muchas gracias

0

Back to top

#2 enecumene

Webmaster

Administrador
7419 posts

LocationRepública Dominicana

Posted 14 October 2010 - 07:48 AM

Esto te puede ayudar

Saludos.

0

Back to top

#3 jorgeu

Advanced Member

Miembro Platino
179 posts

LocationMaracaibo

Posted 27 October 2010 - 02:51 PM

una manera es guardar el archivo en formato CSV e intentar cargarlo con

sql

LOAD DATA LOCAL INFILE &#39;/importfile.csv&#39; 
INTO TABLE test_table
FIELDS TERMINATED BY &#39;,&#39;
LINES TERMINATED BY &#39;\n&#39;
(field1, filed2, field3);