Create a table from an xls or csv file

[ClausAndersen]

Hi!

New to this forum im looking for an easy way to create a table from ex. an xls or csv file?
Would be ok to create all columns as VARCHAR, I could then correct "Type" after the table creation manually.

Have a MySQL 5.5 server on my Mac Pro running OS X 10.7. Also have Sequel Pro, MySQLWorkbench installed, and have phpMyAdmin set up on the server as well.

Im def. NOT an expert in MySQL! Hope somebody can help me :O)

Best regards
Claus Andersen, Denmark

[johny10151981]

hey, follow the link it tells you how you can upload from csv file. be careful when you follow the instruction. some instruction will delete your table.

Another way is if you have phpmyadmin installed then you can upload file in database easily..