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

[@randalsullivan4453]

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

[@excelpowertips7447]

Thanks for that feedback 😊. Please share this Excel Power Tip.

[@Peakprospr420]

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 ------------------------------

[@excelpowertips7447]

What version is your SQL Server Database Engine? In SQL Server Management Studio type this SQL and press F5 to find out: SELECT @@VERSION AS 'SQL Server Version';

[@excelpowertips7447]

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

[@lightyagami14868]

subscribed bro thank u