How to Import Single or Multiple Excel sheets into a SQL Server Database

Welcome Excel Users to my ExcelPowerTips Channel!

This video gives a step-by-step tutorial on how to import your Excel worksheets data (either a single worksheet or multiple worksheets) into
SQL Server Databases.

After importing it you can query or manipulate it using the SQL (Structured Query Language) or practice learning SQL using the imported Excel data.

Enjoy!

Like - Subscribe - Comment - Share

[randalsullivan]

Thank you, a great video! It was concise, informative, and useful!

[excelpowertips]

Try choosing another SQL Server destination from the dropdown and see what happens. Thanks.

[Peakprospr]

I dont see native destination. I created localdb . i see destination called 'Microsoft ole db provider for sql server' which shows server name correctly. however it comes with this error. Im really stuck on how to import my excel work books

TITLE: SQL Server Import and Export Wizard


The operation could not be completed.


ADDITIONAL INFORMATION:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Microsoft OLE DB Provider for SQL Server)


BUTTONS:

OK