can phpmyadmin import excel files
Posted: Sat Nov 05, 2005 2:57 am
i have some data in tabular form in excel.
I have designed equal number of columns ,design table in mysql database...
but it has been difficult to insert data one by one
can that excel data directly inserted as data in table
in excel
A B.............
name Age
Harry 12
in mysql table i have
name varchar(25),
age int,.....
can that excel file impoted as data to mysql table
thanks...
and whats about vice versa ...
from mysql table to excel for print...
i am using phpmyadmin....but can use other soft was well if there are any
thanks
if not from any plian text document to mysql table but not giving commands...(insert into ....
I have designed equal number of columns ,design table in mysql database...
but it has been difficult to insert data one by one
can that excel data directly inserted as data in table
in excel
A B.............
name Age
Harry 12
in mysql table i have
name varchar(25),
age int,.....
can that excel file impoted as data to mysql table
thanks...
and whats about vice versa ...
from mysql table to excel for print...
i am using phpmyadmin....but can use other soft was well if there are any
thanks
if not from any plian text document to mysql table but not giving commands...(insert into ....