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



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!