Tool for creating (My)SQL table from CSV header (no script)

Question

I have to make some queries on several Excel sheets and I think it would be easier if I can put them on a DB and make the queries with SQL.

Is there a tool that creates SQL tables from a CSV file with headers?

JiminyCricket · Accepted Answer · 2011-10-11 14:05:37Z

1

MySQL has functions built in to load data from CSV files. This is probably your best option and one that gives you the most control.

answered Oct 11, 2011 at 14:05

JiminyCricket

7,4807 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Devart · Accepted Answer · 2011-10-11 14:47:27Z

1

Have a look at Data Import tool (Excel, CSV or TEXT formats) in dbForge Studio for MySQL. Import allows to create new table and customize fields in a wizard.

answered Oct 11, 2011 at 14:47

Devart

120k23 gold badges172 silver badges189 bronze badges