SQLTeam.com | Weblogs | Forums

Powershell Script to import multiple excel files into Sql server table

I need powershell script to import multiple excel files into sql server table.

why not just use the import/export wizard?

hope this helps

please look into sql server
SMO objects
sql server managment objects

https://www.sqlteam.com/articles/fast-csv-import-in-powershell-to-sql-server

https://blog.sqlauthority.com/2012/06/27/sql-server-powershell-importing-csv-file-into-database-video/