SQLTeam.com Forums

Powershell Script to import multiple excel files into Sql server table

savibp3 April 17, 2018, 6:55am 1

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

How do I add additional .txt files into a SQL table a .txt file into SQL server

gbritton April 17, 2018, 1:20pm 2

why not just use the import/export wizard?

harishgg1 November 21, 2018, 12:04pm 3

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/