468,550 Members | 1,693 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

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
Oct 19 '11 #1
1 2044
johny10151981
1,059 1GB
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..
Oct 24 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Lauren Quantrell | last post: by
3 posts views Thread by Enver A | last post: by
8 posts views Thread by cainlevy | last post: by
2 posts views Thread by Karen Sullivan | last post: by
1 post views Thread by danths | last post: by
1 post views Thread by vincenthkh | last post: by
reply views Thread by kurtf | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.