By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

Create a table from an xls or csv file

ClausAndersen
P: 1
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
Share this Question
Share on Google+
1 Reply


100+
P: 1,059
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.