Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to create a table from an excel sheet?

Is there an easy tutorial?

I'd like to create a table that exactly matches the excel table, is it possible to do something like "create table from excel sheet"?

like image 747
LaBracca Avatar asked Oct 07 '10 09:10

LaBracca


1 Answers

You can use the Import and Export Wizard if you're only importing a small number of sheets.

In SQL Server Management Studio, right click on the database name, then Tasks -> Import Data. Then follow the wizard.

like image 96
Paul Spangle Avatar answered Sep 22 '22 21:09

Paul Spangle